Set expression how to add one more condition ?

[paulyeo11]

Hi All

sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}>} [TOTAL_AMT])/1

DO filed :-

NOT_INVOICE

Reserve

Now i like to add condition DO=NOT_INOVICE into above expression.

I try :-

sum({$<month-={$(=Num(Month(AddMonths(Today(),DO=NOT_INVOICE,-2))))}>} [TOTAL_AMT])/1

If the above expression is correct , the value display with be same as column 2 Correct column.

Hope some one can advise me.

Paul

[paulyeo11]

my QVF

[Ivan_Bozov · Accepted solution]

Hello! Try this:

sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}, DO={'NOT_INVOICE'}>} [TOTAL_AMT])/1

Result:

[paulyeo11]

Hi Ivan

Thank it work

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>