Skip to Content
0
Former Member
Feb 17, 2011 at 06:55 AM

Sum of variable

52 Views

I have a report data as following:

Invoice | Invoice Line | Supplier | Total Amt

Inv 1 0001 A 100

Inv 1 0002 B 100

Inv 2 0001 A 200

Inv 2 0002 B 200

I have done the report into grouping the data by suppress the Duplicate amount and become following

Invoice | Invoice Line | Supplier | Total Amt

Inv 1 0001 A 100

0002 B

Inv 2 0001 A 200

0002 B

I have use a variable to calculate how much of Supplier available by using count. In order to avoid duplicate Total Amt = 200, I create a variable C = sum(Total Amt) / count(Supplier). But one things is if I want to do the sum for Total Amt for the entire report. I am not able to use the Sum(Total Amt) in Report footer. And I am not able to do the Sum (Variable C). Any idea?