Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
im trying to do this
Sum({<Date = {"$(=Date(Today() - 30))"}>} Stock*WAC)
to take the data for the date 30 days bofore i want it for only one day if its 1/nov i want 2/oct data how can i do it everytime i i try somthing i get 0 even tho i have data for the whole year
Check in a textbox what =Date(Today() - 30) is returning and see if this is matching the format of [Date].
For example, if [Date] is stored in YYYY/MM/DD format but the expression is returning a result in the format DD/MM/YY this will not work.