on 12-13-2016 6:29 PM
Hi,
I am trying to create a running total that only counts the job if it is a specific job with the most recent overdue date.
I tried a formula in the running totals field that used the Maximum Function that looks like this (but it wouldn't accept it):
Field to summarize: VIEW_WORK_REQ_OCC.JOB
Type of summary: count
Evaluate: use a formula - VIEW_WORK_REQ_OCC.JOB="PM-AA-500" and Maximum ({VIEW_WORK_REQ_OCC.DUE_DATE})
Reset: never
Hi Ian,
I was not able to complete the formula because the second formula :
whileprintingrecords;
global numbervar JobCount;
If VIEW_WORK_REQ_OCC.JOB="PM-AA-500" and {VIEW_WORK_REQ_OCC.DUE_DATE} = Maximum ({VIEW_WORK_REQ_OCC.DUE_DATE}, {Group}) then JobCount:= JobCount + 1;
I received an error that read: "A number, currency amount, boolean, date-time, or string is expected here." where "VIEW_WORK_REQ_OCC." appears in the formula.
Help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You will probably need to use a Variable and build your own RT
Needs 3 formula
@Reset -- place this in group header
whileprintingrecords;
global numbervar JobCount:=0;
@Eval --place this in detail section
whileprintingrecords;
global numbervar JobCount;
If VIEW_WORK_REQ_OCC.JOB="PM-AA-500" and {VIEW_WORK_REQ_OCC.DUE_DATE} = Maximum ({VIEW_WORK_REQ_OCC.DUE_DATE}, {Group}) then JobCount:= JobCount + 1;
in group footer insert
@Display
whileprintingrecords;
global numbervar JobCount
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.