Aggr Function

[its_rajvir]

Dear Experts,

Need your help

I have a expression:

Sum(Aggr(Only(ContainerAmount),Primary Key, ContainerID))

It shows the Cash Amount.

Now i want to exclude all the Zero cash amount but i am not able to exclude 0 amount.

Can anyone help please

[Andrea_Spinetti]

If I got your request right, maybe try to use something like: If(Sum(Aggr(Only(ContainerAmount),Primary Key, ContainerID))<>0, Sum(Aggr(Only(ContainerAmount),Primary Key, ContainerID)))

[GeorgePhilips23]

Under OrderID(Dimension) ==>> choose 'Limitation' ==>> choose 'Exact value' ==>>  choose '> 0'