## Formula that will allow me to divide a child by the parent

Regular Contributor

## Formula that will allow me to divide a child by the parent

Hi,

Need help creating a formula that will divide a child in a list by the parent.

screen shot of the formula I have

Looking to take the Amt from both Direct & ISO and divide them by the All BU parent from another module in their specific columns.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Certified Master Anaplanner

## Re: Formula that will allow me to divide a child by the parent

Hi @neg177

Assuming 'All BU' is the 'Top Level Item' of your list, then you can use SELECT to reference parent values as shown below:

Thanks,

LipChean

Community Boss

## Re: Formula that will allow me to divide a child by the parent

Use a LOOKUP of the parent for items other than the first level within the hierarchy and SELECT for the top level for the first level parent.

Chris
HeathcoteAndHerran.com
3 REPLIES 3
Certified Master Anaplanner

## Re: Formula that will allow me to divide a child by the parent

Hi @neg177

Assuming 'All BU' is the 'Top Level Item' of your list, then you can use SELECT to reference parent values as shown below:

Thanks,

LipChean

Regular Contributor

## Re: Formula that will allow me to divide a child by the parent

Thank you. Very helpful and we got the formula we needed.

Community Boss

## Re: Formula that will allow me to divide a child by the parent

Use a LOOKUP of the parent for items other than the first level within the hierarchy and SELECT for the top level for the first level parent.

Chris
HeathcoteAndHerran.com