Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have selected 3 countries:
The numbers in brackets are the ones I want to Sum, but I keep getting 0
Also, please keep in mind, that there are way more countries in the app, so the SUM has to be dynamic and change on the selections.
Currently I am trying this formula, which seems correct, but, as I said, I keep getting a 0
=Sum({<Country={'$(=Country)'},Year={'$(=Year)'}>}Number)
I tried
=Sum({<Country>}Number)
Which did work, but it gave me (what I assume) was the whole sum
Thank you in advance
Any chance you can share a sample of the data? I also assume that the country and Year in the $ Expansion are variables? What are the calculations for those?