Cell count vs. clarity/auditability
I have a calculation module where I'm debating between having more line items so that a future model builder can more clearly understand the math I'm doing vs. having fewer line items to save on cell count.
For example, I have line items, Item 1 and Item 2, that pull a value from a data module. Both Item 1 and Item 2 have some complex If statements to determine which (list formatted) version to select from the data module. I have a 3rd line item, Item 3 = f(Item 1, Item 2). Is it best practice to do it this way or would it be better to delete Item 1 and Item 2 and reference the data module directly in the formula for Item 3? The latter would reduce the cell count, but a future model builder would have a more challenging time understanding the math being done.
Answers
-
Hi @asbernhardt ,
Optimizing space and desigining efficient calculations - both are equally important. And in your example, I would try to use 3 lineitems or more if needed, to simplify the calculation and hence expect calculation engine to run more efficiently than complicating the formula within one lineitem (and making it hard to decode / debug).
Please refer Anaplan's recommended standards, when in doubt:
PS: Appreciate your consideration of understandabiilty of your logic for other model builders.
Cheers!
0
