Forum Discussion

WillVitale's avatar
WillVitale
Contributor
2 years ago

How to pull account type in Excel add-in

Hello, Is there a way to pull the account type in Excel add-in for OneStream? I tried using XFGetCell and XFGetMemberProperty and it didn't work.  Thanks, Will
Excel Add In
Reports
  • aricgresko's avatar
    aricgresko
    2 years ago

    Will - XFGetMemberProperty will do the trick.  Try something like the snippet below where A2 = the account you want the account type for.

    =XFGetMemberProperty("Account",A2,"AccountType","","","")

aricgresko's avatar
aricgresko
Contributor III
2 years ago

Will - XFGetMemberProperty will do the trick.  Try something like the snippet below where A2 = the account you want the account type for.

=XFGetMemberProperty("Account",A2,"AccountType","","","")

  • WillVitale's avatar
    WillVitale
    Contributor
    2 years ago

    Thanks. I didn't realize I needed the final 3 quotes at the end of the formula.