First Non Blank within Hierarchy
Answers
-
go to the blueprint view and change the summary method for those line items instead of writing that within the aggregation formula
0 -
You're 90% there already! For
Rev Rec Start
set the summary to whichever summary you need - Min, Max or Non BlankCreate another line in this module and call it
Parent Rev Rec Start
Here's the formula for it:
Rev Rec Start[LOOKUP: Parent]
1