Hey community, hope you can help me with these one.
In my Data Hub model I have a module to fed the others which includes different columns such as CCs, Accounts, Entities, etc.
For the CCs specifically I create a mapping module which map some CCs to their parent level (these to avoid creating too many cost centers on the rest of the models and keep it simple and at a higher level).
So I need to have my final CC line item: Which takes one CC list at base level if the boolean is off or the high level parent if this is on. But I cannot use the if statement formula for line items with different lists.
Which is the best way to build the formula?