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
Please have a look on below code :
load( local!years: { "2019", "2019", "2018", "2017" }, local!income: { 10, 20, 30, 40 }, local!uniquerYears: union( local!years, local!years ), local!result: a!forEach( items: local!uniquerYears, expression: { year: fv!item, Totalsum: sum( index( local!income, wherecontains( fv!item, local!years ) ) ) } ), local!result)
Thanks now it works