Previous Row from Max Row

Hi I am looking for an expression to refer to a specific row that falls in between MAXROW & MINROW (I know its not correct syntax but something along the lines of either MAXROW -1 or MINROW + 1). There will only be 3 possible rows and there will be 3 different actions needing this specific row data

These are the MAXROW and MINROW formulas for reference:

LOOKUP(MAXROW(โ€œBilling Detailsโ€, โ€œ_ROWNUMBERโ€, [ParticipationID] = [_THISROW].[ParticipationID]), โ€œServicesโ€, โ€œServiceIDโ€, โ€œCPTโ€)

LOOKUP(MINROW(โ€œBilling Detailsโ€, โ€œ_ROWNUMBERโ€, [ParticipationID] = [_THISROW].[ParticipationID]), โ€œServicesโ€, โ€œServiceIDโ€, โ€œCPTโ€)

Thank you

Solved Solved
0 2 176
1 ACCEPTED SOLUTION

Aurelien
Participant V

Hi @Allison_Romero1

Does this link help you ?

View solution in original post

2 REPLIES 2

Aurelien
Participant V

Hi @Allison_Romero1

Does this link help you ?

Thank you very much, yes it does. I didnโ€™t think of it this way, I was stuck on MAXROW and MINROW.

Top Labels in this Space