Hi,
I have been trying to use an allocation for costs, and am struggling to make a two dimension allocation work correctly. The issue is one of the dimensions (FinanceDimension4) is optional and not mandatory, so am wanting to have the calculation take that into consideration, as when I choose it as an override it is ignoring it as an option to be blank. So when I currently run it with the custom total of "300" then it is only taking into consideration scenarios where both finance dimension 3 and finance dimension 4 are populated which is incorrect in our use case.
Any thoughts?
This is the code we currently have on the custom compute:
BenefitSplits is a ComputeField
type is Decimal size 20.2
(total(GeneralLedgerTotal."300",FinanceDimension3=FinanceDimension3,FinanceDimension4=FinanceDimension4,GeneralLedgerTotal.EntityYearPeriod=AllocationContext.Period).NetUnitsAmount)
Thanks,
Sam