find next row and go to one specific column

[JoannaM]

Hi all

I have an operation plan (production) and I have to find the next operation to be done.

I have found the max_date and therefore found the last operation which has been done.

Now I need to show the next operation step. The data is the next row and then the colum where the work center is located.

How can I get there?

Thanks for the Input.

Best regards, Joanna

[Sammy_AK]

you can use set analysis to find the details of next column. lets say there are 2 columns Plan_Production and Next_operation.

to find the las operation you have applied Max(Plan_Production) to get the max date, similarly you can apply set analysis to find the next operation date: =Only({<Plan_Production = {"=Max(Plan_Production)"}>}Next_operation)

hope this works... if not, can you post some sample table with data or QVF file ?

[JoannaM]

Hi

Thank you for your answer.

I have a picture below what I am looking for exactly.

I have found the last date (max date) and the last step in the production (work center) but I need to show the next step (work center).

Yellow mark is what I have and the green mark is what I need to see.

Thank you so much for your help.

BR, Joanna

[Sammy_AK · Accepted solution]

if the table looks exactly how it is, i have an alternate approach to this solution. instead of looking for last available date, i will look for blank values in column "operation plan" and look for minimum step, which is nothing but the next step and the expression: only({<step = {$(=Min({<operation_plan={''}>}step))}>}operation_date).  

[JoannaM]

Thank you so much! Worked perfectly.