Page 1 of 1
Tubo Integrator function to return weight?
Posted: Fri Oct 15, 2010 7:23 pm
by ChrisF79
Greetings:
I'm writing a Turbo Integrator process and need to multiply by the weight of the parent of an element. For example, I have an account 14600 - C02. It's parent is 14600 and has a weight of -1. When I come across account 14600 - C02, I need to look up the weight of the parent. Any way of doing that?
Re: Tubo Integrator function to return weight?
Posted: Fri Oct 15, 2010 7:54 pm
by tomok
Rule functions can be used in a TI process too. Look in the help file for the rule functions for dimensions and elements and I'm sure you'll find what you are looking for. Keep in mind you can nest functions if need be.
Re: Tubo Integrator function to return weight?
Posted: Fri Oct 15, 2010 7:57 pm
by kpk
ChrisF79 wrote:Greetings:
I'm writing a Turbo Integrator process and need to multiply by the weight of the parent of an element. For example, I have an account 14600 - C02. It's parent is 14600 and has a weight of -1. When I come across account 14600 - C02, I need to look up the weight of the parent. Any way of doing that?
You can use the rule functions in TI:
ELWEIGHT(dimension, element1, element2)
dimension A valid dimension name.
element1 The name of a consolidated element within the dimension.
element2 The name of a child of the consolidated element.
HTH
Re: Tubo Integrator function to return weight?
Posted: Fri Oct 15, 2010 8:13 pm
by ChrisF79
kpk wrote:ChrisF79 wrote:Greetings:
I'm writing a Turbo Integrator process and need to multiply by the weight of the parent of an element. For example, I have an account 14600 - C02. It's parent is 14600 and has a weight of -1. When I come across account 14600 - C02, I need to look up the weight of the parent. Any way of doing that?
You can use the rule functions in TI:
ELWEIGHT(dimension, element1, element2)
dimension A valid dimension name.
element1 The name of a consolidated element within the dimension.
element2 The name of a child of the consolidated element.
HTH
That'll do it. Thank you!