How to get an investment rate of a sub-subsidiary company using functions and coefficients?

[Former Member]

Dear Experts!

"The problem is that destination amount must multiply to the interest rate of a definite company (partner), which we get using Coefficient and Function in Rules."

I thought that the problem was that the system FC doesn't count consolidated amount.

Now I tested this case and see that the core of the problem is that on the TOP scope there are no data with the interest rate of a top company to this definite partner (which is a jointly-controlled organization), because this company is in sub-subsidiary scope. To fully understand the situation with companies you can see the screenshot below:

The company 20070001 is a parent company and the company 20010031 is jointly-controlled organization to the parent company 20070001. the company 200100031 is in Sub-subsidiary scope, because it is the Subsidiary company of the Subsidiary of Sub-holding (20010002) of the Parent Company (20070001). I hope you got the right hierarchy.

The scope of the Parent company includes only investment rates of subsidiary companies, but not subsubsidiary companies. (as you see below).

The question is that I need to use the investment rate of the sub-subsubsidiary company to multiply to the amount using Coefficient. Below is the Coefficient we used to get all investment rates.

What is the name of a variable that shows the investment rate of sub-subsidiary to use it in the Coefficient?

Thank you in advance!

portfolio.png (5.8 kB) investments.png (19.8 kB) rate.png (11.4 kB)

[Marc_Kuipers · Accepted solution]

Hi Nani

In the Function screen, click on either "rates" or "variables"

If it's not listed there, then the variable does not exist

Thanks

Marc

[Former Member · Accepted solution]

Thank you very much Marc!!!

It works now! I appreciate a lot!