This content has been marked as final. Show 6 replies
I have a max date variable ( vMaxDate=Max(Date) ) and I want to use it in set analysis both for calculations for max date and for previous max date.
The max date works, this is the formula:
But how do I do it for previous date, without creating another variable?
This formula DOES NOT work:
***if I do it without using variable, it works, but I want to use a variable.
Without variable the formula is like this: