Total Calculation Help

[STiGuy2006]

Hi,

I have total calculation question...

Example:

If Price is 0 and Volume is 50, I want the total to show 50 and not /0. Is this possible? I have a few query calculations dependent on the total and its messing everything up. Price and Volume are not members or measures, rather they are query calcs based off measures.

Thanks

[MFGF]

How have you defined the syntax of your calculation currently?

Have you tried an if-then-else construct to look for zero in Price?

MF.

[STiGuy2006]

Thanks for the reply..

Yes, I have and no go.

Price is based off of ASP (Measure) (Revenue Divided by Units) and there were 0 units but a negative revenue for that line. Now that I think of it that could be why. I'm thinking of trying a custom query calc of ASP with an IF statement for the 0. Hopefully it works!