Removing (-VE) and 0 Sales Amount & Quantity

[#1]

Hello there folks,

I was just wondering - how I can go about removing and 0 values from a report?

End user has complained that, the and 0 results have been interfering with the average price calculation. They do have a point there, it is no longer accurate.

I tried this if-statement in the expression, if ( A > 0, A), it only substitutes the amount rows with a dash, but the total sales amount didn't change it remains the same as before the statement was included.

Please advise. Thanks in advance.

Best Regards,

Ram

[Anonymous]

In the load script you could have a flag indicating if the value is positive.

E.g.

Load

     *,

     If(revenue>0,1,0) as _FlagPositiveFacts,

     revenue

From

....

then in your charts you could have set analysis to only include facts where _FlagPositiveFacts =1

[#3]

Hi Damian,

Thanks for your suggestion.

Just curious, if I was reluctant to do any modification in the load script. Is it possible to do this in the report expression?

What am trying to say is, if there is some other work around?

Thanks in advance, mate!

[Anonymous]

Hmm not too sure. As this is average you want to exclude the line items from the possible data set. I can only think of this via a filter which is set analysis. However would be interested to be informed otherwise.

[tresesco]

I guess proper use of IF or set analysis could help you. Can you explain your issue with an example or post a sample app?

[#6]

Thanks anyway. I have already figured it out.

[#7]

Thanks anyway. I have already figured it out.