Total Mode (SUM)

Wed, 09 Nov 2011 15:13:59 GMT

Guys

I currently have a straight table will a few expressions calculating the required fields. One of these expressions is returning me the right value on each record but the wrong value in total.

I have changed the "Total mode" on the straight table to Sum the total value is right now.

But the issue now is that I need the total from the above in the neted expression to work out %.

I think the function required is aggr but not 100 sure how to get this working.

Example below.

(

(sum(A)/sum(TOTAL <CUST> A))*sum(TOTAL <CUST_NAME> B)

)

(if(isnull(Sum(NET)/sum(A))=-1,0,Sum(NET)/sum(A))

)

(

(if(isnull(Sum(NET)/sum(A))=-1,0,Sum(NET)/sum(A))

)

sum(B)

)

values in the records are

0.1

0.4

0.5

0.6

0.7

total of 2.3

If i put the expression on a text box the answer is zero.

thanks

topic Total Mode (SUM) in QlikView

Total Mode (SUM)