Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
In order to see all unallocated cash (to a customer account) I use the following expression:
Sum({<
[code of cash applied]={'unallocated'},
[date of cash applied]={"<=$(=today())"}
>}[cash applied total USD])
Now I want to see what case was unapplied till end of last month. This in order to see the difference between today and end of last month.
What expression do I need to use for the date of cash applied?
Ugur
Hi,
Can you try this:
[date of cash applied]={"<=$(=today())>=$(=MonthEnd(AddMonths(Today(),-1)))"}
Best,
Ali A
Hi,
That'd be
Sum({<
[code of cash applied]={'unallocated'},
[date of cash applied]={"<=$(=MonthEnd(AddMonths(today(), -1)))"}
>}[cash applied total USD])
Hope this helps.
Juraj