Issue in sum in a concatenate table

[#1]

Hi,

Please find attached the qvf and data set.

I have a concatenate table, and trying to get the sum for all column as below.

but its showing as zero.

sum(Activity1+Activity2+Activity3+Pcost+Tcost)

But when i am individually doing it, i am getting the desired value.

sum(Activity1)+sum(Activity2)+sum(Activity3)+sum(Pcost)+sum(Tcost)

Can you please help me to understand the difference.

For set analysis, i would required the expression 1, but it will be difficult to apply the set analysis in 2nd expression.

Can you please help me on this.

Thanks

Prasanta

[Chanty4u]

did u try

=Sum(column1,column2,colum3,pcost,cost)

[sunny_talwar]

Try this as well:

RangeSum(Activity1, Activity2, Activity3, Pcost, Tcost)

The issue is related to Summing of Null Values. If one of those values are Null, then Sum doesn't know how to handle it.

[#4]

No, even its not working.

its only showing the sum for 1 customers. not for all.

Can you please see the attached qvf