Formula Logic Help
Got a question I need assistance with.
I have a number of lists that follow a hierarchical list, account level 4, 3, 2 ,1. At level 4 each account also belongs to an accounting group (online, local etc) and has a signage value of either 1 or -1.
The accounting group and signage are contained within a module called account lowest level mapping.
I am attempting to create a module consolidates my profit and loss by accounting group instead of the hierarchy that is set up.
The module uses the account group dimension and has a line item for amount. The current formula is 'Profit and Loss Module'.Month[SUM: Account Lowest Level Mapping.Account Group] which is incorrect as it does not include the signage.
If I use 'Profit and Loss Module'.Month[SUM: Account Lowest Level Mapping.Account Group] * lowest level mapping.signage this is incorrect as it needs to multiply each account level 4 item by the signage first, and then sum by account group.
Is this achievable through formulas alone? Or do I need another module to multiply the signage through first which I then sum by.
Any assistance would be appreciated.
I'm probably oversimplifying this but could you just use a System module for L4 and create a line item that holds the signing? Then you can look it up anytime you need and for any purpose. If you need a different sign based on channel (online or local), just make a two dimensional system module.1
Hi Jared, thanks for the reply I appreciate it.
Im not sure I follow. Ive only completed the level 1 model builder so im still learning the ropes of Anaplan.
Just for clarification I have a List for the different account levels 4 rolls up to 3, 3 to 2 etc. I also have a list for the different accounting groups.
I have a module for level 4 mapping and within that module contains the signage for each level account level 4 item along with a signage for each of those items.
I have a profit and loss module that contains the data for level 4 against month and version.
So what I am attempting to do, is for each level 4 item in the profit and loss module, multiply it by the signage in the mapping module and then sum by account group for each month.
Does that make sense?0
Take a look at these resources, they may help you here:
Modeling Video Series #2: Signage Convention - Anaplan Community
Changing the Sign for Aggregation - Anaplan Community0