First Non Blank within Hierarchy

howard
edited November 2023 in Modeling

Hi, how do I get the first non blank, or min, or max on the date here within the hierarchy. The first 3 lines should all have the same date 9/25

Answers

  • go to the blueprint view and change the summary method for those line items instead of writing that within the aggregation formula

  • You're 90% there already! For Rev Rec Start set the summary to whichever summary you need - Min, Max or Non Blank

    Create another line in this module and call it Parent Rev Rec Start

    Here's the formula for it:

    Rev Rec Start[LOOKUP: Parent]