Forum Discussion
TheJonG
10 months agoContributor III
I may need a bit more information but it sounds like this should be possible by using the Unbalanced functions which are used within an api.Data.Calculate with data buffer which have different dimensionalities. Here is an example:
Dim povEntity As String = api.Pov.Entity.Name
Dim S_povEntity As String = $"S_{povEntity}
api.Data.Calculcate($"A#OutstandingDays = Divide(1, DivideUnbalanced(A#COS, E#{s_povEntity}:A#Creditors:U1#None:U2#None, U1#None:U2#None)")
The above formula may seem a little confusing due to the order of operations that is required for the unbalanced functions. The idea behind the unbalanced functions is that one of the arguments in your formula has more dimensions defined than the other and this argument always has to be listed second so we need to flip the division in this case, which is why we take 1 divided by the result. The result of this will be that we can divide the two data sets and still have UD1 and UD2 detail.
Related Content
- 2 months ago
- 11 months ago
- 9 months ago
- 11 months ago