HELP. Using CR 9 and cant figure out how to do percentages

[jaybar48]

Hi. CR 9 is supposed to allow percentages. I can't figure out where to go to enable this. Can anyboby walk me through how to do percentages?

Basically I have two summary fields A and B in each cell. Both are running totals (distinct counts). I would also like to display what % A is of B in each cell.

Can anybody help. I can't see any check box to activate percentages.

 

[synapsevampire]

Since you use the term cell, I'll assume that you're creating a cross-tab:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_percent_of_distinct_count.pdf.asp

If not, you can create a formula to calculate the percent as:

(b/a)*100

Keep in mind that Running Totals in the details will not have a group level total, use the standard summary functions to have them available at that level.

-k

 

[jaybar48]

Hi SynapseVampire

The formula b/a*100 won't work. When I create it, it does not appear in the field list for the croostab as one of the fields I can use as a summary field.