Doing Calculations Across Models

[ahfadoo]

Hi! I'm looking to perform a very simple calculation across two different models and having the amount be placed in the table of the second model:

So essentially in this example, I would like to have the actual in the first model(to the left) multiplied by the value in the second model(to the right) and have the final amount be inputted into target in the second model(on the right). Is there any way to do this?

Thanks!

[N1kh1l · Accepted solution]

ahfadoo

ahfadooLINK formula in Member formulas could have worked for you but if its a new model LINK formula is not supported in new model with measures. If its a planning model, you can try the LINK Model formula in Data Action Advanced formula.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/18850a0e13944f53aa8a8b7c094ea29e/afe93e3cf1414a7b8419b...

Br.

Nikhil