Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i have requirement to show previous month results based selection,
if i select April then it has to show mar results how can i achieve
can any one help me to built set expression
thanks and regards,
kavitha
hello,
i have built a set expression like this
i am getting month based on selection previous month but aggregation is not happening.
it is returning 0 though i have value.
Sum({<DATE = {"=MonthName(DATE) = MonthName(AddMonths(max(DATE), -1))"}>}IN_CHARGE)<DATE = {"=MonthName(DATE) = MonthName(AddMonths(max(DATE), -1))"}>}IN_CHARGE)
MonthName(AddMonths(max(DATE), -1))--this is giving previous month based on selection.
sum({<DATE = {"=MonthName(DATE) = MonthName(Today(), -1)"}>}IN_CHARGE)----this expression working statically
i want set expression in such a way based on current month selection it has to show previous month results.
please help on same
thanks in advance,
kavitha