Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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:
Sum({<DateNum={"$(=$(vMaxDate))"}>} Quantity)
But how do I do it for previous date, without creating another variable?
This formula DOES NOT work:
Sum({<DateNum={"$(=$(vMaxDate)-1)"}>} Quantity)
This formula doesn't work either:
Sum({<DateNum={"$(=$(vMaxDate-1))"}>} Quantity)
Where in the formula (if it's possible at all) I have to put -1 so it will work?
***if I do it without using variable, it works, but I want to use a variable.
Without variable the formula is like this:
Sum({<DateNum={"$(=Max(DateNum-1))"}>} Quantity)
Thanks
Hi Linoy
Have you put an "=" sign in the variable itself?
No. That's why I'm using it set analysis.
Actually, I added it as you suggested, and it really seems to work now.
I'll make a double check anyway.
Thank you!
When you say the formula is not working is it returning an error or is it giving the same result as max(date) ?
Because your previous date formula will give you the previous day...
The same result as a max date...
I'd be glad if you could explain to me why it works this way.
I used the equal sign (=) in set analysis but it wasn't enough, and only when I added it to the variable as you've suggested - it worked.
Im not to sure of the reason, Maybe someone else could explain.
I do believe the answer lies in the type of object you are using the variable in, it may behave differently in a straight table as what it would in a text object.
I understand.
Thank you very much!
You've helped me a lot!!!