Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Yes, you are right.
If you provide qvw file, that will help me to understand it properly.
Regards,
Kaushik Solanki
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
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.
Hi,
Yes, you are right.
If you provide qvw file, that will help me to understand it properly.
Regards,
Kaushik Solanki
Thanks I have updated the other expressions and it now works