Solved
Monthly vs Quarterly allocation of accounts
Hello,
We are trying to automate a simple allocation of specific corporate expense accounts. The accounts allocate to different business based on their contribution to total GP. I currently have ...
Your table confuses me. But when I see division and parent members involved, there are almost always order of operation issues to consider that can only be solved through Dynamic Calcs.
Depending on what you need to do, you can choose to vary your formula based on the View such as:
If api.Pov.Time.MemberId=DimConstants.Periodic Then
'Periodic formula
ElseIf api.Pov.Time.MemberId=DimConstants.QTD Then
'QTD formula
End If
Or, you can include V#Periodic in each operand of your formula, so that regardless of the user's POV View, you will compute using Periodic.
Divide(A#BUGP:V#Periodic,A#TotalGP:V#Periodic)
