SAC Microsoft Excel (Formula Error)

[former_member809799]

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?

[former_member809799 · Accepted solution]

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.

[N1kh1l]

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

[amartya_ghosh2023]

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))

[Subhasmit]

Hi seamustaylor88,

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

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

Thank You.

[N1kh1l]

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

Nikhil