Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I would like to compare the following values in a table:
These are my formulas:
1. Sum of my sales of the current year:
Sum ({<Year={$(VmaxYear)}>} ([Sales]))
1. Sum of my sales of the last year:
Sum ({<Year={$(VPrevYear)}>} ([Sales]))
BUT for last year only until the current week.
How would I have to script this? I was thinking about defining a variable that is then inserted into the "Sum ({<Year={$(VPrevYear)}>} ([Sales]))" command.
Thank you for your help!
Jan
Perhaps this: Sum ({<Jahr={$(VVorjahr)}, Woche={'<=$(=max({<Jahr={$(VmaxJahr)}>}Woche)'}))>} ([Sales]))
Hi Gysbert
Thank you. Looks good. But does not work yet...
Best
Jan