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

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

Find more posts tagged with

Formulas

Accepted answers

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), "")

All comments

Leibel S

@Crystal Panning

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

Crystal Panning

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.