Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
¿There is a way to get on a button the total sales minus current year?
Thank you
You could try set analysis in the button expression.
Sum(Sales)-Sum({$<This Year = {1}>}Sales)
Use you identifier/flag for this year in the set analysis of the second sum.
I may have misunderstood what you are asking.
Do you want the calculation in a text object that appears once you click on the button?
If you can explain what you want the button to do, that help in providing a more accurate answer.
Tom
Hello,
you are right, i ment in a text objext
May be like this
Sum({<Year = {"$(='<=' & Max(Year))"}>}Sales)
Within the text object text box -
=Sum(Sales)-Sum({$<Year = {This year}>}Sales)
That should work.