Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Any ideas?

Former Member
replied

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

Regards,

Raghavendra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question