New to the website… I have a simple 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.

What is the datasource your building your report on? A cube, then you can create a calculated measure for it.

What are trying to calculate? price per item? and if you get the value 50 in your total column, this will mess your calculation, right? If you have 50 items which are free (price = 0) would you not want 0 in the total instead of 50?