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
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
Rev Rec Start
Create another line in this module and call it Parent Rev Rec Start
Parent Rev Rec Start
Here's the formula for it:
Rev Rec Start[LOOKUP: Parent]
Hi, I have a form action button that adds a L5 list item to a hierarchy. L5 does not have selective access but L4 does, but I still see all L4 list items in the dropdown when I trigger the form. How can I only view the ones I should have selective access to? L5 does not have selective access. L4 is also a selector on thisβ¦
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-yearβ¦
