RANKEQ with a date criteria

Brucey

Hi there,

I am trying to pull the most recent fee payment value from each regional group. I want this to pull through to a report so that I can see that most recent payment value In a report where all the regions appear once.

I have the region column (called DNO) the fee payment column (called A&D fees) and the date column to determine the most recent (DNO offer received). But I also have a days since column to help with the formula

I'm getting stuck pretty early as I don't know how to incorporate the date/ days since :

=RANKEQ([A&D Fees]@row, COLLECT(DNO:DNO, DNO@row, ))

Any help would be great

Paul Newcome

You shouldn't need the extra column.

=IF([DNO offer received]@row = MAX(COLLECT([DNO offer received]:[DNO offer received], DNO:DNO, @cell = DNO@row)), 1)

The above will output 1 (or check a box if using that type of column) for the most recent entry for each region.

Paul Newcome

You shouldn't need the extra column.

=IF([DNO offer received]@row = MAX(COLLECT([DNO offer received]:[DNO offer received], DNO:DNO, @cell = DNO@row)), 1)

The above will output 1 (or check a box if using that type of column) for the most recent entry for each region.

Brucey

Legend thanks Paul

Paul Newcome

Happy to help. 👍️