How to filter more then 1 items ?

[paulyeo11]

Hi All

I just Add GL_CODE = 50010 to below expression :-

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"},[GL_CODE] = {"50010"}, month = ,year=>}[Amount])), $(vCurrency)))

I need to Add one more GL_CODE = 50011 , may i know how to add ? so that my SET expression will filter 50010 and 50011.

Paul

[vivek_niti · Accepted solution]

Hi,

Try this...

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"},[GL_CODE] = {"50010","50011"}, month = ,year=>}[Amount])), $(vCurrency)))

Regards,

[Sokkorn]

Hi Paul,

It seem that your GL code is a number. Let try

[GL_CODE] = {50010,50011}

Regards,

Sokkorn

[paulyeo11]

Hi Vivek

Thank you vrey much your working.

Thank you Sokkom for good try.

Paul

[er_mohit]

You simply write this way

[GL_CODE] = {50010,50011}

[paulyeo11]

Hi er , Thank you very much , it work fine .  since i need to filter GL Code from 50010 till 50030, meaning total 20 number , how to avoid writing all the individual number , and just use from 50010 till 50030 , it there have such code in QV ?

Paul

[paulyeo11]

my QV Doc

[er_mohit]

Sorry for late reply.

For this situation you could try like this

and i can't open your app. coz, i m working on personal edition..

[GL_CODE] = {">=50010<=50030"}

[paulyeo11]

Hi er

your suggestion work fine . many thank it make my life easy.

Paul