selecting jobs that exceed a specific date

[tkaplanusmc]

I am trying to select jobs exceeding specific preassigned dates for a Lead Time report. in the examples below im trying to show jobs in the planning workcenter that exceed 27 days, and then for purchasing im trying to reflect 24 days late from promised date. thank you in advance for the help.

*Note that the report is already grouped my workcenters and i have eliminated the drill down for each group to just show a total number of jobs in each work center for one field, and then this function im trying to create to show out of those jobs which ones are considered late.

@late

if {Job_Operation.Work_Center} = "Planning"
and {Delivery.Promised_Date} >= today -27 then count({Job_Operation.Job}, {Job_Operation.Work_Center})
else if {Job_Operation.Work_Center} = "Purchasing"
and {Delivery.Promised_Date} >= today -24 then count({Job_Operation.Job},{Job_Operation.Work_Center})

-Tyler

 

[lbass]

if {Job_Operation.Work_Center} = "Planning" and
{Delivery.Promised_Date} >= today -27 then 1 else
if {Job_Operation.Work_Center} = "Purchasing" and
{Delivery.Promised_Date} >= today -24 then 1

Place this in the detail section and insert a sum (not count) on it at the group level. Drag the result into the group header, if that's where your other fields are.

If you mean to have separate counts for planning and purchasing, then use two formulas, instead of this combined one.

-LB

 

[tkaplanusmc]

thank you very much for the quick response! I'll play with this.