The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

MitPower01's avatar
MitPower01
New Contributor II
2 years ago
Solved

Looking for sample Excel Add-in function XFGetMemberInfo for Account

I tried using this function to pull the account description but keep getting an error.  I'm sure because I am using the wrong fields.  I looked for samples but can't find any.  XFGetMemberInfo Thi...
Excel Add In
  • aricgresko's avatar
    aricgresko
    2 years ago

    XFGetMemberInfo only has 3 arguments.  If you wanted the description for an account called "Revenue", you would use this syntax.
    =XFGetMemberInfo("Description","Account","Revenue")

MitPower01's avatar
MitPower01
New Contributor II
2 years ago

Thank you so much!  I couldn't find that example anywhere in the admin guides.  And the fact that function template has 5 fields I would never have guessed.  Thanks Again!

  • aricgresko's avatar
    aricgresko
    Contributor III
    2 years ago

    You're welcome.  The easiest way I know of to check what arguments need passed in, is to begin writing the function in excel and clicking on the function arguments (fx) icon.