Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm trying to get the sum of the sales from last business year to todays date a year ago:
sum({<
Businessyear = {$(=year(today(2))-1)},
Billingdate < {$(=Date(AddYears(today(2), -1)))}
>}
Sales)
How can I get here the sales till the date a year ago? Seems like this '<' operator doesn't work with the Billingdate field.
Thanks!
Try this
sum({<
Businessyear = {"$(=year(today(2))-1)"},
Billingdate = {"<$(=Date(AddYears(today(2), -1)))"}
>}
Sales)
Try this
sum({<
Businessyear = {"$(=year(today(2))-1)"},
Billingdate = {"<$(=Date(AddYears(today(2), -1)))"}
>}
Sales)
Looks good thanks!