on 03-22-2024 5:01 AM
Hello experts,
Context: we have two models. One model containing COGS per unit for each FG while the other model contains Sales with other sales relevant dimensions. We would like to transfer the dimensions from the sales model to the COGS model, as well as calculating the COGS amount given the Sales dimension.
For example: "ZSACP_M01" is the COGS model and "ZSACP_M02" is the Sales model. We would like ZSACP_M01 to copy the dimensions information from ZSACP_M02, as well as use the lookup results to calculate the COGS amount to COGS measure in ZSACP_M01. (All "COGS/unit" is stored in 202401)
So far, we have tried this advanced formula script, which resulted in no change to the model:
Variable Member #1 of [d/Customer A]
Variable Member #2 of [d/Customer B]
Data ([d/measure] = "COGS/unit", [d/Customer A] = #1, [d/Customer B] = #2) = Resultlookup([d/Measure] = "COGS/unit")
Data ([d/measure] = "COGS") = Link([ZSACP_M02],[d/Version] = "public.Actual", [d/Measures] = "Sales_Quantity") * Resultlookup([d/date] = "202401", [d/measure] = "COGS/unit", [d/Customer A] = #1, [d/Customer B] = #2]
Please advise us on improving this formula. Thank you so much!
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.