on 2018 Mar 02 6:47 PM
Have a report with (5) groupings, (3) of which are suppressed, the detail section is not suppressed. I need to return the number of days between today and the max date found in the UPCDateFinish field, where Production Complete = 0. Grouping on jmpJobID and others as shown below.
The (4) fields and (3) tables I'm working with are "Jobs.jmpJobID", "JobOperations.jmoProcessID", "JobOperations.jmoProductionComplete", "UPortalClocks.UPCDateFinsh".
Example data would be:
JOBID.....ProcessID.....UPCDateFinish.....ProductionComplete (Boolean 0/-1)
123.....010.....3/1/2018.8:02am.....-1
123.....020.....3/1/2018.8:15am.....-1
123.....030.....3/1/2018.8:25am.....-1
123.....040.....(null).....0
456.....010.....3/1/2018 8:03am.....-1
456.....020.....3/1/2018 8:17am.....-1
456.....030.....(null).....0
Design View
Print Preview
Should be able to create a formula
If jmoProductionComplete = 0 then
Datediff("d", today, maximum({UPCDateFinish}, {jmpJobID})
else 0
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
65 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.