In need of a formula that takes the amount in the Children rows and divides by a Parent row total

Crystal Panning

I am in need of a formula that takes the amount in the children rows and divides by a Parent row (ideally would make a column formula). My current formula for the attached is the below (one of many formulas tried).

=IF(CHILDREN([Merchant Revised Casepack Quantity]@row > 0, [Merchant Revised Casepack Quantity]@row / (PARENT)([Merchant Revised Casepack Quantity]@row, ())

I also tried =[Merchant Revised Casepack Quantity]@row / PARENT([Merchant Revised Casepack Quantity]@row) but did not work either.

Any help is appreciated!

Formula needed.png

Leibel S

@Crystal Panning

Try the below, it should work as a column formula too

=IF(AND(PARENT([Merchant Revised Casepack Quantity]@row) > 0, [Merchant Revised Casepack Quantity]@row > 0), [Merchant Revised Casepack Quantity]@row / PARENT([Merchant Revised Casepack Quantity]@row), "")

Leibel S

@Crystal Panning

Try the below, it should work as a column formula too

=IF(AND(PARENT([Merchant Revised Casepack Quantity]@row) > 0, [Merchant Revised Casepack Quantity]@row > 0), [Merchant Revised Casepack Quantity]@row / PARENT([Merchant Revised Casepack Quantity]@row), "")

Crystal Panning

Thank you for responding so quickly! I will try the formula you provided, appreciate your help!