HI @Jbob

Thanks for the post. I have tried to recreate your example (in a simple way) to see where the issue is.

In mine the column called Date and the column called Max per Value are BOTH Date data types.

I have exposed the formula I have used in the last column to show how the Max per Value is coming through.

I know this has simplified your original question, but can you see how the Max(Collect()) statement works here?

Does this help at all?

So in yours:

=MAX(COLLECT({CQ Hours Data Range 6}, {CQ Hours Data Range 2}, Model@row, {CQ Hours Data Range 5}, Batch@row),)

Range 6 and the column you have written this formula into must be Date fields and you have an extra comma where you don't need it! Just between the last two )). This comma will cause an error.

Kind regards

Debbie