How to filter non zero values from an expression result

[#1]

Hi

I have the following fields in the Chart (Straight Table),

e.g.

                         Expression             Expression                           Expression

                         using                      using                                   using  

                         Set Analysis           Set Analysis                        Set Analysis

                         value between          value between                      AA set Analysis -

                         2 dates                    2 dates                               BB set Analysis

Invoice_Num       Amount (AA)          Payment_Amount (BB)             NET_AMT

A1                    1000.00                    500.00                                    500.00

B1                    2000.00                    2000.00                                      0.00

C1                    3000.00                    1500.00                                 1500.00

I want to show records where the NET_AMT is not zero, i.e. only show Invoice number A1 and C1. How can I do this.

Thanks in advance.

Rgds

Fahad

[er_mohit · Accepted solution]

you have to write for both column AA and BB is

if(column(3)=0,expression for Column AA)

same for Column BB

and make sure check on Suppress Zero Value in Presentation Tab

[#3]

Try to click on the search button of the list box. Then for not its <>. Im not sure if it works with <>0 or if you have to write <>0.00. Just try it.

[jvitantonio]

Hi, please check app attached.

[#5]

Thanks a lot. It works.

[#6]

Thanks a lot. It works.

[#7]

It didn't work.

Thanks

Rgds

Fahad Cader

Group IT

Aitken Spence PLC

Tel: +94 11 2 308 043