3 Replies Latest reply: Apr 20, 2016 6:41 AM by Prasanta Kumar RSS

    Issue in sum in a concatenate table

    Prasanta Kumar

      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