Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Suppose if today is 03/23/2017 and i want to build an expression for sum of amount
from 04/23/2016 to 05/23/2016 then how to build it.
what should be the set analysis for it?
sum({<>}Amount).
Thanks,
Jean
May be this
Sum({<DateField = {"$(='>=' & Date(AddYears(AddMonths(Today(), 1), -1)) & '<=' & Date(AddYears(AddMonths(Today(), 2), -1)))"}>}Amount)
Try something like this by creating a datenum field
{<numDate = {">= $(=num(Max(AddMonths(Date,-10)))) <=$(=num(Max(AddMonths(Date,-11)))) "}>}
May be this
Sum({<DateField = {"$(='>=' & Date(AddYears(AddMonths(Today(), 1), -1)) & '<=' & Date(AddYears(AddMonths(Today(), 2), -1)))"}>}Amount)