topic Re: Set expression how to add one more condition ? in App Development

Set expression how to add one more condition ?

paulyeo11 — Sun, 28 May 2017 12:06:02 GMT

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 — Sun, 28 May 2017 12:08:43 GMT

my QVF

Ivan_Bozov — Mon, 29 May 2017 22:20:56 GMT

Hello! Try this:

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

Result:

paulyeo11 — Mon, 29 May 2017 22:36:53 GMT

Hi Ivan

Thank it work

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804