Trying to add a local member, but it's not recognized and kept as an Excel formula

[SAPSupport]

Trying to add a local member 'Calc' but system not able to recognize it as a local member and keeping it as Excel formula only.

We want to add the local member to a sheet. The formula we are trying to add is as below:

"=IFERROR(SUM(K5:L5)/(SUMIFS(K:K,E:E,E5,F:F,F5,G:G,G5)+SUMIFS(L:L,E:E,E5,F:F,F5,G:G,G5)),0)"

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hi Aasif,

Please go ahead and review the following SAP Help Portal Pages, so that you can set up the Formula for the Local Member correctly:

Local Members
Local Member Creation
Local Members - Examples

Thank you!

Best regards,
Zsombor