0

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

Mar 28, 2017 at 04:25 AM

51

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?

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

Marc Kuipers
Mar 28, 2017 at 08:33 PM
1

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

p1.jpg (121.5 kB)
p2.jpg (143.5 kB)
Show 1 Share
Former Member

Thank you very much Marc!!!

It works now! I appreciate a lot!