Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=sum({<[Amt USD] = {"=[Amt USD] <> 0"}>}[Amt USD])