CRXI
Hi. Please help me with this:
I had the question bellow and I got an answer from LB. It was very good, but now I noticed in the report a mov appears more than once; appears for every job.
“
I have a group on job. How do I take only the mov which have the latest date?
job mov date
1059 GCI4410 25/04/2011
ICI4443 08/05/2011
1058 GCI4410 25/04/2011
1060 GII1060727 13/06/2011
ICI4514 05/07/2011
1061 GII1060844 29/05/2011
ICI4487 14/06/2011
1065 ICI4543 25/07/2011
1064 GCI4493 19/06/2011
ICI4561 11/08/2011
1062 GCI4493 19/06/2011
ICI4561 11/08/2011
1068 GCI4507 08/07/2011
ICI4543 25/07/2011
1069 ICI4582 08/08/2011
Desired output
job mov date
1059 ICI4443 08/05/2011
1058 GCI4410 25/04/2011
1060 ICI4514 05/07/2011
1061 ICI4487 14/06/2011
1065 ICI4543 25/07/2011
1064 ICI4561 11/08/2011
1062 ICI4561 11/08/2011
1068 ICI4543 25/07/2011
1069 ICI4582 08/08/2011
Go to report->selection formula->GROUP and enter:
{table.date}=maximum({table.date},{table.job})
If you need to do calculations across jobs, be sure to use running totals, since non-group-selected records are still "in" the report, though not displayed, and would contribute to the more usual subtotals. Unlike suppression, with group selection, you don't have to explicitly exclude non-group-selected records.
“
Now appears like this:
1059 ICI4443 08/05/2011
1058 GCI4410 25/04/2011
1060 ICI4514 05/07/2011
1050 ICI4443 08/05/2011
1061 ICI4487 14/06/2011
1065 ICI4543 25/07/2011
1064 ICI4561 11/08/2011
1062 ICI4561 11/08/2011
1068 ICI4543 25/07/2011
1051 ICI4443 08/05/2011
1069 ICI4582 08/08/2011
Any idea?
Hi. Please help me with this:
I had the question bellow and I got an answer from LB. It was very good, but now I noticed in the report a mov appears more than once; appears for every job.
“
I have a group on job. How do I take only the mov which have the latest date?
job mov date
1059 GCI4410 25/04/2011
ICI4443 08/05/2011
1058 GCI4410 25/04/2011
1060 GII1060727 13/06/2011
ICI4514 05/07/2011
1061 GII1060844 29/05/2011
ICI4487 14/06/2011
1065 ICI4543 25/07/2011
1064 GCI4493 19/06/2011
ICI4561 11/08/2011
1062 GCI4493 19/06/2011
ICI4561 11/08/2011
1068 GCI4507 08/07/2011
ICI4543 25/07/2011
1069 ICI4582 08/08/2011
Desired output
job mov date
1059 ICI4443 08/05/2011
1058 GCI4410 25/04/2011
1060 ICI4514 05/07/2011
1061 ICI4487 14/06/2011
1065 ICI4543 25/07/2011
1064 ICI4561 11/08/2011
1062 ICI4561 11/08/2011
1068 ICI4543 25/07/2011
1069 ICI4582 08/08/2011
Go to report->selection formula->GROUP and enter:
{table.date}=maximum({table.date},{table.job})
If you need to do calculations across jobs, be sure to use running totals, since non-group-selected records are still "in" the report, though not displayed, and would contribute to the more usual subtotals. Unlike suppression, with group selection, you don't have to explicitly exclude non-group-selected records.
“
Now appears like this:
1059 ICI4443 08/05/2011
1058 GCI4410 25/04/2011
1060 ICI4514 05/07/2011
1050 ICI4443 08/05/2011
1061 ICI4487 14/06/2011
1065 ICI4543 25/07/2011
1064 ICI4561 11/08/2011
1062 ICI4561 11/08/2011
1068 ICI4543 25/07/2011
1051 ICI4443 08/05/2011
1069 ICI4582 08/08/2011
Any idea?