Displaying Percents in Report Footer.

[cfriedberg2]

I have a report that has lots of detail sales data. I am displaying only the group footer and a summary of sales data and the percentage of the groupings based on the grand total. That is working fine.

However, I want to show the percentage (100%) in the report footer. When using the dialog box for inserting percentages, there is none for the report footer. Running totals of percentages does not work either.

I am using version 9

 

[synapsevampire]

Choose grand total, it will place it in the report footer.

-k

 

[cfriedberg2]

If you want to Calculate the Sum, the Option "Show as a percentage of " is disabled.

 

[synapsevampire]

Just write a formula:

(sum({table.sales}),{table.groupfield})/distinctcount({table.groupfield}))*100 &"%"

Since it's always 100%, I'd just put in a text box...

-k