Sum expression - only display totals greater than one

[cliff_clayman]

I have a simple straight table with 3 values, Name, Vendor and # of Purchases.  I want to exclude from the result set the # of Purchases that equal 1.  How can I do that?

[jyothish8807]

Hi Cliff,

Go to dimension tab, Select Date dimension and select "Suppress when value is null'.

Hope that works.

Regards

KC

[sunny_talwar]

This expression is nullifying all those places where Sum(Purchases) <= 1. That's what you want, right? You might be seeing null because of your settings on the properties tab. Make sure Suppress Zero Value is checked and Suppress missing/null is checked.

Also do you just have one expression or multiple expressions?

[cliff_clayman]

Now I am attempting to add in another expression for Total Purchase $.  How do I incorporate the expression for # of Purchases into the one for Total Purchase $ to only give me the totals for the charges that are greater than 1?

Sum(Charge Amount$)    -----  Label[Total Purchase $]

[sunny_talwar]

Is the first issue resolved? For total purchase amount, may be this:

If(Sum(Purchases) > 1, Sum([Charge Amount$]))

[cliff_clayman]

Yes, the initial and secondary issues are now solved.  Sorry for all the confusion and thanks for the help!!

[sunny_talwar]

Awesome