Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
DO filed :-
NOT_INVOICE
Reserve
Now i like to add condition DO=NOT_INOVICE into above expression.
I try :-
If the above expression is correct , the value display with be same as column 2 Correct column.
Hope some one can advise me.
Paul
Hello! Try this:
sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}, DO={'NOT_INVOICE'}>} [TOTAL_AMT])/1
Result:
my QVF
Hello! Try this:
sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}, DO={'NOT_INVOICE'}>} [TOTAL_AMT])/1
Result:
Hi Ivan
Thank it work
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>