Forum Discussion

MitPower01's avatar
MitPower01
New Contributor II
12 months 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
    12 months 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
12 months 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
12 months 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.