All unallocated cash receipt till end of last month

[ugurarslan]

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

[bwisealiahmad]

Hi,

Can you try this:

[date of cash applied]={"<=$(=today())>=$(=MonthEnd(AddMonths(Today(),-1)))"}

Best,

Ali A

[juraj_misina]

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