I am looking to return the single max date from different groups of values. What I tried was typing "max(max({Maintenance Invoice}.{Project ID}.{Invoice Date}), max({Maintenance Invoice}.{Project 2 ID}.{Invoice Date}))", but that didn't work.
I want to return the maximum (newest) date from Maintenance Invoice/Project ID/Invoice Date or Maintenance Invoice/Project 2 ID/Invoice Date, whichever is newest? Is this possible?
Rob Yost shared this idea · Feb 23, 2022
Comments
1 comment
Hello Rob,
Yes, it is possible. Since the MAX() function is a Child Aggregate function, you will want to conduct the computing in the Child Table, and then sort that data in the Parent table.
For this specific case, you will want to have a formula in the Child table that will calculate which Invoice Date is the newest for the record. This most likely can be determined with an IF() statement. Once the calculation is complete in the Child table to show the Newest Date for the Child Record, then you can have the Calculated field in the Parent table to determine the maximum Invoice Date out of ALL the Children.
If you would like for our support team to help you dive into this formula more in detail within your specific account, please email support@trackvia.com.
Thank you,
Leeana
Please sign in to leave a comment.