RANKEQ with a date criteria

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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.