Hi,
I have 2 arrays:
local!years: {"2019", "2019", "2018", "2017"}
local!income: {1,2,3,4}
So the value in "income" is corresponding to its year in the "years".
and I want to get this data like : "year" - sum("income")
2019 - 3
2018 - 3
2017 - 4
And I am trying to loop
local!yearsUnion: union(local!years,local!years),
local!res: a!forEach(items:local!yearsUnion,expression: with(local!year: fv!item,local!impact,a!forEach(items: local!years,expression: with( local!val: 0,
if(local!year == fv!item,local!val = local!val + local!income[fv!index],local!val = local!val + 0))
)))
But I am not getting what I want. I can find how I can return the value from the nested loop, so to connect it with the value of the parent loop
Any suggestions?
Discussion posts and replies are publicly visible