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

[OmarBenSalem]

Could you please show as 5 lines of ur table maybe so that we can work on ur data directly?

Thanks

[agigliotti]

maybe you have to untick "Include zero values" option under Add-ons->Data handling section.

[Arthur_Fong]

try this:

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

[Thiago_Justen_]

Here it is some tips:

1 - As Andrea already said, you can untick "show zero values" option;

2- You could also try this expression sum({<[Amt USD]={">0"}>}[Amt USD])

3- Or this one: Only({<[Amt USD]={">0"}>}[Amt USD]);

4- Considering that Amt USD has null values:

sum({$-<[Amt USD]={"*"}>}[Amt USD])

I hope it helps you. But if not, please share a mock up with us.

Cheers

[MayilVahanan]

Hi

For if condition, you can try like below

If(sum([Adj Amt USD])<>0, sum([Adj Amt USD]))

[ugurarslan]

Thanks a lot, but the table contains and positive and negative amounts for an example 1 and -1. Will this function also apply to these?

[hamza99a]

you could do an if statement.

if(sum(AMT)=0,0,NULL)

[balabhaskarqlik]

May be try this:

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

[balabhaskarqlik]

Or try this:

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