how to calculate the sum including null values

[#1]

suppose  I calculating the  sum of sales. in that sales have some null values means in that format(-) are their . so how to calculate the sum of sales in that example any one plz tell me...... urgent 

[ashfaq_haseeb]

Simply write

=sum(sales) as your expression.

regards

ASHFAQ

[#3]

For clarity sake you could also exclude dimensions with value Null (Suppress when value is null)

[jagan]

Hi,

Just use

=Sum(MeasureName)

It will work.

Regards,

Jagan.

[er_mohit]

Try this expression

sum(Sale)

Make sure in presentation tab you uncheck the suppress zero value  to see the null values

[#6]

Hi,

You can add this in your script

sum(sales)

Regards

Charitha