Date criteria in set analysis

[#1]

Hi Experts,

How can I add a specific filter criteria (field name) in the following expression instead of hard values, I would like to get the value which is lesser than or equal to the selections.

The filter name is: DocDate

Sum({$<DocDate = {'<=08/30/2016'}>} Debit) - Sum({$<DocDate = {'<=8/30/2016'}>} Credit)

Kindly help!

[jagan]

Hi,

Try like this

For max date selected

Sum({$<DocDate = {'<=$(=Max(Date))'}>} Debit) - Sum({$<DocDate ={'<=$(=Max(Date))'}>} Credit)

OR for Today date

Sum({$<DocDate = {'<=$(=Today())'}>} Debit) - Sum({$<DocDate ={'<=$(=Today())'}>} Credit)

Regards,

Jagan.

[#3]

Thanks Jagan.

[jagan]

Hi Shazad,

If you got the answer close this thread by giving Correct Answer, so that it would be helpful for others.

Regards,

jagan.