Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Thanks 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.