I have a child table with a date and a number. I would like to pull back the number for the child record with the highest date. The date field does not correlate with the create or modify date.
Child table:
01-05-2020 6
01-23-2020 10
01-15-2020 20
Returned value would be 10
MichaelW shared this idea · Jan 29, 2020
Comments
2 comments
Hi Michael,
Thank you for reaching out! This would be possible via a few calculations on both the parent and child tables.
On the parent table, you can use the max() function, to return the most recent date.
max({Date on Child Table})
On the child table, you can then return the Number field, for those records whose date is equal to the max({Date on Child Table}) date.
if({Field on Parent created above}={Date on Child Table},{Number on Child Table},null())
Lastly, on the parent table, use the childconcatenate() function on the field you created on the child table, which should only include the number with the highest date.
childconcatenate({Calc field on Child Table})
If you would like further assistance, feel free to submit a ticket to our support team at support@trackvia.com for us to take a further look.
Best,
Cristina
I already had the max date on the child table, so all I had to do was add the two other calculations. Seems to work. Thanks.
Please sign in to leave a comment.