sum in report

[KimVong]

I have 2 subreport in on report. And I have a sum of each report in the report footer. So what I did in the final report under report footer, I make a grandtotal of the total on each of the subreport, by having this formula in the report.

let's say it's text63 is the name of the grandtotal text.
in the data, I have (reports![table1]![text1] + reports![table2]![text1]).

But when I try to use this grandtotal text to give me the percentage in the first table by doing this.

sum(expr1/reports![table3]![text63]), and the format is percent, it didn't give me anything.

can anyone help me?

 

[CMooreJr]

have you just tried...

sum(reports![table3]![text63]/100) ??

 

[KimVong]

the problem I have is, if I just type in report![table3]![text63], it will give me the grandtotal number, and whenever I put in the sum(reports![table3]![text63]), nothing shows up. It's really weird how that happen.
do you know why?
thanks so much for helping too. I really want to find out this is the case on my end