Sum of value upto day-1

[#1]

Dear All,

I am facing issue during the calculation of value upto day -1 (date is in a selection).

I have written following formula, kindly help.

(sum({$<[transaction date],[branch code]={'605'}, [account number]={'060510945231'},NDate={'>=$(=(1))<=$(=(num([transaction date])-2))'}>}Tran_Amt))

Where [transaction date] is a date

NDate is a numeric of date.

Thanks & Regards,

Aqeel Nawaz

[MK_QSL · Accepted solution]

(sum({$<[transaction date]=,[branch code]={'605'}, [account number]={'060510945231'},NDate={'>=$(=(1))<=$(=(num([transaction date])-2))'}>}Tran_Amt))

[alexandros17]

Try deleting all other condition in your sum to test the date part:

sum({$<NDate={'<=$(=num([transaction date])-2)'}>}Tran_Amt)

This expression is enough

Let me know

[jagan]

Hi,

Try this

=sum({$<[transaction date]=, [branch code]={'605'}, [account number]={'060510945231'},NDate={'<=$(=Max([transaction date])-2)'}>}Tran_Amt)

Regards,

Jagan.

[#5]

I used to hard-code branch & account #. Your provided code is not working.

My aim to sum value from its instance to upto date-1.

[#6]

Thanks issue resolved, it was my mistake to miss spell NDate which is Ndate.

Also thanks to Manish Kachhia, his hint "=" helped me.

[jagan]

Hi,

Please close this discussion by giving Correct and Helpful answers to the posts.

Regards,

Jagan.

[er_mohit]

Try this

sum({<[transaction date]=,[branch code]={'605'}, [account number]={'060510945231'},

NDate={'>=$(=(1)<=$(=num([transaction date])-2)'}>}Tran_Amt)