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?