3702056 - SAP Analysis for Office workbook not showing expected result after changing sign option to "Reverse Sign"

After query changing sign option to "Reverse Sign", the query output shows expected result in transaction RSRT but not in Analysis for Office workbook:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Analysis for Microsoft Office 2.8
• SAP Analysis for Microsoft Office 2.8, edition for SAP Analytics Cloud

reverse sign, sign option, query change, query definition, navigational state, RSRT, AO, AfO, workbook, analysis workbook. , KBA , BI-RA-AO-XLA , Excel Addin , Problem