Question Re: SAC Microsoft Excel (Formula Error) in Technology Q&A

SAC Microsoft Excel (Formula Error)

former_member809799 — Thu, 04 May 2023 11:45:19 GMT

Hi All,

I am creating a report in excel using the SAPGETDATA formula. I'm getting a #VALUE! error on refresh but when I click into the formula itself and click out the formula displays the correct value although if I refresh the workbook again, the #VALUE! error comes back.

I have tried hard coding dimensions, getting rid of any excel formatting, excel fixes related to the number type/text, recreating the formulas from scratch, using a data source instead of a table as the SAC source but nothing seems to work...

Has anyone else encountered this error before and knows how to fix the issue?

Re: SAC Microsoft Excel (Formula Error)

Subhasmit — Thu, 04 May 2023 12:13:12 GMT

Hi seamustaylor88,

please o through with this link https://help.sap.com/docs/SAP_ANALYSIS_OFFICE_CLOUD/b25c777a2c8c4e3da2f472cce24f289c/40a626bf6c65465fb51d694920c4b39e.html

if this is helpful for you then please upvoted or accept this answer .

Thank You.

Re: SAC Microsoft Excel (Formula Error)

amartya_ghosh2023 — Thu, 04 May 2023 12:17:21 GMT

Hi,

I can not face particular this type of error. but to work around this scenario, you will try a combination of AVERAGE along with IF and ISERROR to determine if there is an error in the specified range. This particular scenario requires an array formula:

=AVERAGE(IF(ISERROR(B2:D2),"",B2:D2))

Re: SAC Microsoft Excel (Formula Error)

N1kh1l — Thu, 04 May 2023 12:59:55 GMT

seamustaylor88

I can see you are comparing the value returned by GETDATA() with "-" (unbooked) condition. The return from GETDATA() is not of type string so may be the comparison with "-" (quotes will make it string") is causing issue. I tried to recreate your logic at my end. See below.

I have SAP.GETDATA() for 3 months. January is unbooked.

Now I just compare if SAPGTDATA for january is 0 then SAPGETDATA for february else january

I don't see any issue at all.

Hope this helps

Nikhil

Re: SAC Microsoft Excel (Formula Error)

N1kh1l — Thu, 04 May 2023 13:00:53 GMT

The above is for SAC AFO, the question is regarding SAC Add-in for excel.

Nikhil

Re: SAC Microsoft Excel (Formula Error)

former_member809799 — Mon, 08 May 2023 11:08:47 GMT

Thanks for your input everyone.

The formula was working fine but there was a missing currency rate so the issue was actually with the underlying data.