Issue adding new formula to Cross-Tab
I'm not too bad creating formulas but I've never had the need to add them to a Cross-Tab report. I can see the new formulas in the Report Fields section when in the Formula Editor and Field Explorer, but not in the Report Fields section when creating or updating a Cross-Tab.
I've done everything I can think of. I'm guessing that it's because of some issue with CR 8.5, but I don't have a choice right now. I can't upgrade due to compatibility issues.
Insert the summary field as count(field) in the crosstab and then again insert the same count(field) in the summary.
Now in the design select the second summary field
>go to format field>Commaon Tab >Display String (X+2)>write the formula like
(currentfieldvalue/grand total) * 100