SAC Microsoft Excel (Formula Error)

[#1]

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?

[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