Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Simply write
=sum(sales) as your expression.
regards
ASHFAQ
For clarity sake you could also exclude dimensions with value Null (Suppress when value is null)
Hi,
Just use
=Sum(MeasureName)
It will work.
Regards,
Jagan.
Try this expression
sum(Sale)
Make sure in presentation tab you uncheck the suppress zero value to see the null values
Hi,
You can add this in your script
sum(sales)
Regards
Charitha