Show me amounts not equal to zero

[ugurarslan]

Dear all,

I am trying to write a query which shows me all amounts not equal to zero.

I wrote these expressions but it doesn't work.

=sum({<[Amt USD]-={"0"}>}[Amt USD]) =  I still see zero

If(sum([Adj Amt USD])>0 or sum([Adj Amt USD])<0,sum([Adj Amt USD])) = It shows me also NULL values.

I just need to see all AMT USD not equal to zero.

Thanks

Ugur

[hamza99a]

=sum({<[Amt USD] = {"=[Amt USD] <> 0"}>}[Amt USD])