on 11-24-2023 11:59 AM
Per the following AFO screenshot:
I'm trying to get the value of "Actual Amount GC USD" for 0GL_ACCOUNT hierarchy node HFSV11 using the SAPGetData function, but I'm having issue with the syntax for +NodeKey(NodeTypeName) parameter.
Below is what I'm using. What's wrong with the syntax?
=@SAPGetData("DS_1"|"Amount"|"0GL_ACCOUNT+NodeKey(NodeTypeName)='HFSV11'")
I'm using the documentation from https://help.sap.com/docs/SAP_ANALYSIS_OFFICE_CLOUD/b25c777a2c8c4e3da2f472cce24f289c/40a626bf6c65465...
Thanks!
Regards,
Mel Calucin
hello,
from my experience, single quotes are redundant.
=@SAPGetData("DS_1"|"Amount"|"0GL_ACCOUNT+NodeKey(NodeTypeName)=HFSV11")
even this should work
=@SAPGetData("DS_1"|"Amount"|"0GL_ACCOUNT+NodeKey(NodeTypeName)="&A8)
Best Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.