Total of Rows

[#1]

I have the following straight table which gives me no of days each stage is taking for applications. In the expression for Total I am saying "Stage 1" + "Stage 2" + "Stage 3" + "Stage 4". It only works if there is no dash (- ) in the row i.e. Loan. How can I get total of the rows which include dash (- ) in it i.e. Overdraft and Masterplan rows? Or should I convert - into 0??? 

No of days
Product	Stage 1	Stage 2	Stage 3	Stage 4	Total
Loan	1	2	3	2	8
Overdraft	2	-	2	5	-
Masterplan	3	4	2	-	-
	6	6	7	7	8

[m_woolf]

Try:

Sum(Stage1) + Sum(Stage2) + ...

[#3]

Thanks Michael. I tried Sum("Stage1") + Sum("Stage2")+.... but it did not work. Stage1, Stage 2, .... are expressions label

[#4]

Also sorry I have pivot table

[#5 · Accepted solution]

The dash represent null() or missing data

And a number + a null = null : the null propagates

Use rangesum() instead: with that function, the null is not propagated

rangesum(A, B, C) = A+B+C  (all null values are treated as 0

Fabrice

[#6]

Hi Aunez,

Really apprecited your help. Basically application can go in any stage and can skip any stage. So you are saying if application does not go in any stage then it will result in - . How can I skip this dash in pivot table. I could not understand whats you said that "And a number + a null = null : the null propagates"???

[Anonymous]

try [Stage 1]+[Stage 2]+[Stage 3]+[Stage 4]

[#8]

In presentation tab, you have textboxes to handle the null display

In QV, if you want to sum several datas with the + sign, if one of these data (in one field, in one expression) is null, then the global result will be null => the null propagates

Fabrice