11-21-2023 04:19 PM
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
Solved! Go to Solution.
11-22-2023 09:04 AM
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","","","")
11-22-2023 09:04 AM
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","","","")
11-22-2023 11:32 AM
Thanks. I didn't realize I needed the final 3 quotes at the end of the formula.