Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement wherein i need to calculate averages for 3, 5, 10 year in text boxes and this leads me to use aggr function as i would need to calculate sumproduct on each year. But the problem is that when a selection on year is made the value gets messed up even though i have passed year=, modifier in the set analysis due to the usage of aggr function.
So would like to know if there is any way to solve this.
if not can i ensure that the user is unable to make any year selections on this particular sheet alone.
Do you use {<Year =>} in the outer aggr function also?
Sum({<Year = >} Aggr(......, ....))
What expression you have used?
Can you provide it here?
Do you use {<Year =>} in the outer aggr function also?
Sum({<Year = >} Aggr(......, ....))