Forum Discussion
iterate through another table
Hi,
I have a still to do list of task pr productionsection and these task have different order of handling, so one task needs to be finished first before another one should start. I only wants to show the task that currently needs to be carry out. I need some kind of dummy in a calculated column.
example:
task B needs to be finish before C and C before D, A Can be start anytime and should show in the list regardless.
The
productsection task dummy (filter later in report)
1. A 1
1. B. 1
1. C 0
1. D 0
2. A 1
2. C 1
2. D 0
2. E 0
Desired list
1.A
1.B
2.A
2.C
3 Replies
How about this?
- Duplicate the original task list twice
- In the first, filter where task = A
- In the secon, filter where task != A, then group by ProductSection and use the Min of Task
- Append the two copies of the task list
- Merge the appended lists to the original task list
Hi Anonymous
you can do it like this:
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
