Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i would like to calculate a value;
Rolling seven days (today-7 days)
*
sum(Levererat Antal)
i have the following syntax which is incorrect i see;
sum({<Leveransdatum={today()-7}>}[Levererat Antal])
Best,
Brad
Hi,
You can try with the below code.
sum({<date={">=$(=AddMonths(Max(date-6),0))<=$(=Max(date))"}>} Value).
Regards,
Tom
Try this:
sum({<Leveransdatum={'$(=Date(today()-7,'MM/DD/YYYY')'}>}[Levererat Antal])
I am assuming that Leveransdatum has date format like MM/DD/YYYY.
HTH
Sushil
Hi i still have syntax error,
Sorry, there is an error
Try this one:
sum({<Leveransdatum={'$(=Date(today()-7,'MM/DD/YYYY'))'}>}[Levererat Antal])
Hi it is not working unfortunately,
do i need to create a new variable?
i have already a variable that vToday = Today() -7;
can i use this in the expression
=sum({<Leveransdatum={'$(=vToday,'YYYY-MM-DD)'}>}[Levererat Antal])
Date format is also YYYY-MM-DD
Best,
Bradley
Hi,
You can try with the below code.
sum({<date={">=$(=AddMonths(Max(date-6),0))<=$(=Max(date))"}>} Value).
Regards,
Tom
Try this:
vToday =Date(Today() -7,'YYYY-MM-DD')
Then expression
=sum({<Leveransdatum={'$(vToday)'}>}[Levererat Antal])
or
=sum({<Leveransdatum={"=$(vToday)"}>}[Levererat Antal])
if still it is not working then post the sample application.
HTH
Sushil