How to add filter on Reporting Code 1 to 11 into my Expression ?

[paulyeo11]

Hi All

I have a Expression which is working fine :-

money(

fabs(

sum(Amount/$(Columndim89))/1000)

, $(vCurrencyFormatK))

How to add below filter into above expression :-

[Reporting Code]

='>=' & 0001 & '<=' & 011

[tresesco · Accepted solution]

Try this:

money(

fabs(
sum( {$<[Reporting Code] = {">=0001<=011"}>} Amount/$(Columndim89), $(vCurrencyFormatK))

Thanks.

[paulyeo11]

Hi Tresesco

Thank you very much . it work.

Paul