Hello Experts, I've to manage a calculation with Advanced formulas.
I've operator 1 (Quantity) on Default model, I've operator 2 (COGS per unit) on Linked model
I've to write the results of Operator 1 * Operator 2 on Default model, but some dimension member value must be driven from Operator2: for example Partner company and currency
for Currency I can use a masterdata relationship, but for Company how can I override the source member with operator2 member? if I don't specify a value for Partner company the records are created for all the partner companies
DATA([d/Measures] = "M_AMOUNT", [d/ACCOUNT] = "C_COGS", [d/Currency] = [d/Company].[p/currency], [d/AS_PCOMPANY] = ???) = RESULTLOOKUP([d/Measures] = "M_QTY", [d/ACCOUNT] = "T_QTY") * LINK([OPERATOR2], [d/Version] = "public.CurrentPlan", [d/Measures] = "M_AMOUNT")I've simplified the case, Operator1 contains many other dimensions that are correct for the result and therefore should be the left member of the calculation.do you have any suggestion how to handle this problem? thanks for your collaboration.Kind regards