Two Workarounds to Avoid the #REF! Error in Percentage of Total Formulas

Reading time: 17 mins

If you are involved with reporting from SAP BusinessObjects Planning and Consolidation, you may have seen formulas that work until the expansion settings are changed and the result is a #REF! error message in Excel. Typically, this type of error can result when reports are defined with Excel formulas that show the percentage of total...

This content is for SAPinsider Monthly Subscription, SAPinsider Annual Subscription, and SAPinsider Premium Annual Subscription members only.
Log In Join Now