10-26-2023 05:59 PM
Hello,
I'm working in the excel add-in and creating a some reports for my company and was wondering if you can use Column Better/Worse in the add-in. I know you can with cube views or quick views, but those limit the formatting we want. The reason I want this is to be able to differentiate between account types when it's doing the comparison like it does in Spreadsheets or in Cubeviews.
Thanks,
Will
10-27-2023 10:30 AM
You can create a dynamic UD8 calc and use that in your b/w column.
10-27-2023 02:15 PM
I agree with Chul. We've got a couple of different U8 members that read Account Type for various situations which can be referenced. I assume you're using getcell pulls, so for the greatest flexibility I'd probably use a U8 that returns the account type itself (something like Return api.account.getaccounttype(api.pov.account.memberid).name. Then call it with a getcell:
10-27-2023 02:16 PM
Forgot to call out that you'd need v#annotation in my getcell example.