Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone
I need a sum on a interval but the max value of the interval is going to be selected by the user. for example if i have year field going from 1997 to 2007 and the user selects 2005 I need the total of CA from 1997 to 2005. I tried every possible set Analysis expression I could think of.
Thanks in advance for your help
Have you tried something like
=sum( {<Year = {"<=$(=max(Year))"}>} CA)
Have you tried something like
=sum( {<Year = {"<=$(=max(Year))"}>} CA)
Hello,
See the attached file. Hope it helps you.
it does work! THANK you so much both of you for helping me, I got lost at a certain point, trying every possible expression i could think of. have a lovely weekend