Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am looking for an expression that SUM's a field total (DeliveryQuantity) if another field date (DateEnded) is within the last 365 days.
I want to show the live total based on today-365.
Thanks.
Hi,it could be something like:
Sum({<DateEnded={">=Today()-365"}>} DeliveryQuantity)
or Sum({<DateEnded={">=$(=Date(AddYears(Today(),-1)))"}>} DeliveryQuantity)
or flag the records while loading data: If(DateEnded>=Today(1)-365, 1, 0) as is365Days. then you can use Sum({<is365Days={1}>} DeliveryQuantity)