- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
find next row and go to one specific column
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much! Worked perfectly.