Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the set expression to find out "Revenue" at "Latest Year":
=sum({1<Year={'$(=(max(num#(Year))))'}>}Revenue)
Now, I have a list box with a field Year, which is used in above expression too. I want that even if I select any value in that list box (that contains Year), the above expression must not change.
Can you please help?
=sum({1<Year={'$(=(max({1}num#(Year))))'}>}Revenue)
=sum({1<Year={'$(=(max({1}num#(Year))))'}>}Revenue)