C
Chris
I have a report where I use the sum function twice like so:
Text Box "Total Feb Views": =Sum([Feb.Views])
Text Box "Total Mar Views": =Sum([Mar.Views])
I then sum the above like so:
Text Box "Total Views": =[Total Feb Views] + [Total Mar Views]
When I preview the report, all is fine in the world. But when I export to
Excel, the cells where the value of "Total Views" should be are empty/blank,
even though there is data for "Total Feb Views" and "Total Mar Views".
Same thing happens if I do the following:
Text Box "Total Views": =Sum([Feb.Views]) + =Sum([Mar.Views])
I'll admit I'm a newbie. What am I missing?
Text Box "Total Feb Views": =Sum([Feb.Views])
Text Box "Total Mar Views": =Sum([Mar.Views])
I then sum the above like so:
Text Box "Total Views": =[Total Feb Views] + [Total Mar Views]
When I preview the report, all is fine in the world. But when I export to
Excel, the cells where the value of "Total Views" should be are empty/blank,
even though there is data for "Total Feb Views" and "Total Mar Views".
Same thing happens if I do the following:
Text Box "Total Views": =Sum([Feb.Views]) + =Sum([Mar.Views])
I'll admit I'm a newbie. What am I missing?