Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
values
1
2
3
4
5
6
-
-
-
-
10
15
16
-
-
-
Is it possible to sum the above columns where '-' means null values, without using suppress null value condition?????
Hi,
You can use the Sum(values) expression. If those "-" are actual dash signs you better change them in the script to zeroes or nulls, but the Sum() should return correct values. If you cannot do that, use the following expression to exclude those "-" signs:
Sum({< values -= {'-'} >} values)
Hope that helps.
Miguel
Hi,
What do you mean by summation of null values here?
Celambarasan
Suppose i have sales column and it contains 10 rows,out which 4 rows does'nt have any values, it only shows dashes symbol '-'.......
Hi,
Do you need to remove that rows?
Celambarasan
Hi,
Try this
Count(if(isnull(Value),Value))
Regards,
Kaushik Solanki
no,i just want the summation of that field
Hi,
You mean value is dimension and another field is expression.
You need to achieve sum(FieldName) for non null values?
Please explain little more briefer?
Celambarasan
Hi,
I am Sorry I didnt understand what you want. Can you please explain in detail. If possible pls give one example
Regards,
Kaushik Solanki
Did you try what I suggested above both just Sum() and Sum() with set analysis?