Excel Formula =SUM() Returning #NA in SAP Analysis for Office (Consolidation Report)

[Hassan_Jawed1]

Hi Experts,

While working in SAP Analysis for Office (AFO) in a Query built on Custom Analytical Query Fiori application using the Data source “Group Data Analysis - Cube (I_MATRIXCONSOLIDATIONREPORTC)”, an error occurs when using Excel formula "=SUM()" after inserting a new row via the Analysis Design tab.

Steps to Reproduce:

1. Open the Query in AFO

2. Go to Analysis Design → Add New Line

3. Apply Excel formula "=SUM()"

Expected: Formula should calculate correctly.
Actual: Returns #NA.

Before Applying SUM Formula:

After Applying SUM Formula:

Has anyone faced this issue before or found a workaround to make Excel formulas work correctly in such AFO reports?

Thanks in advance!

— Hassan Jawed