4 Replies Latest reply: Jun 29, 2011 6:44 AM by JennyHughes

# Expression - Return result if figure does not equal zero

I have a straight table that has a number of expressions which return numeric figures. On one of the expressions I need to filter out anything that does not equal zero. My current expression is Sum(Settled). What should my expression be to return: sum(settled), only if settled does not equal zero? The result would be that the straight table only shows results when the settled figure is not zero, regardless of what the other expressions return.Thanks.

• ###### Expression - Return result if figure does not equal zero

Hi,

You can use the set analysis for this. For example.

Sum({<Settled -= {"0"}>}Settled)

This will give you sum only when the settled is not 0.

Regards,

Kaushik Solanki

• ###### Expression - Return result if figure does not equal zero

Thanks - I've tried that but its not working. Is it becasue all of the other expressions in the table need to contain the same statement - for example one column shows Tax - should I use Sum({<Settled -= {"0"}>}Tax) and so on for other expressions? Thanks.

• ###### Expression - Return result if figure does not equal zero

Hi,

Yes, you are right.

If you provide  qvw file, that will help me to understand it properly.

Regards,

Kaushik Solanki

• ###### Expression - Return result if figure does not equal zero

Thanks I have updated the other expressions and it now works