Skip to main content
M
Marco
December 12, 2023

Delete accounts with a value if 0 in a specific scenario

  • December 12, 2023
  • 2 replies
  • 0 views

Hi Everyone.

Is there a way to delete accounts in a scenario that have a certain value, for example, 0?

2 replies

C
chul
December 12, 2023

My first question would be how did the zeros get there? You can wrap calculate statements in RemoveZeros and they won't populate in the first place.

To answer your question, yes, you can write a business rule to evaluate data points and depending on the value, change the value and/or cell status.

J
JackLacava
December 13, 2023

Can you delete Account members with code, if certain intersections contain zeroes? Yes.

Can you delete Account members for some scenarios only? No, if they go they go for all Scenarios (although you can use Extended dimensions, so that certain Accounts don't show up for certain Scenario Types).

Would you want to actually do any of this? Probably not. Among other things, it might create problems with historical data that exists for that Account, which would likely be lost. If you don't want your "empty" Accounts to show up in reports, just use the relevant suppression options; if you want to stop using a certain Account going forward, use the InUse property.

M
MarcoAuthor
December 13, 2023

Hi JackLacava, 
How can I delete the account through the condition? I don’t know how to do it in the BR.

J
JackLacava
December 13, 2023

The API call is BRApi.Finance.MemberAdmin.RemoveMember, you will find it in the api tree. If you don't know how to look for intersection values or how to create the necessary PK objects to pass, I'd suggest checking out the Financial Calculations Handbook book, or coming to a Rules class.

I might sound patronizing, but I would also suggest you implement this as a Custom Calculate function, and take good backups before you start executing it. Having it as part of a regular Calculate would be very risky. What you are trying to achieve has the potential to be very destructive, I really would not recommend it.

Terms & ConditionsAccessibility statement