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
S