How to implement "hardcoded" logic with best practice in following example
I have the following challenge in modeling the target module. I need to aggregate data before calculation to account level 1, but there is an exception for certain accounts where I need to aggregate those for level 2. I have tried to create system account details where I flag those accounts which are exceptional accounts.
I have marked yellow lines which are exceptional accounts that should be aggregate in account level 2.
Thanks in advance,