Skip to main content
W
WillVitale
November 21, 2023
Solved

How to pull account type in Excel add-in

  • November 21, 2023
  • 1 reply
  • 0 views

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

Best answer by aricgresko

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","","","")

1 reply

A
aricgreskoAnswer
November 22, 2023

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","","","")

W
WillVitaleAuthor
November 22, 2023

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

Terms & ConditionsAccessibility statement