I have a report that allows me to run the total remaining hours for jobs in our shop. I want to modify the report to show 'behind hours' based on a cut off date parameter. After I added in the parameter field into the report it cuts off the total remaining hours that used to calculate for the job. Trying to figure out how the cut off date parameter relates to the total hours. Here is the formula for remaining hours and behind hours:
Remaing Hours
if
{@complete}=true then 0 else if
({job_routing.setup-time}+{job_routing.hrs-piece}*{job_routing.QtyToMfg})/3600<=
{job_routing.act-setup-hrs}+{job_routing.act-run-hrs} then 0.01 else
({job_routing.setup-time}+{job_routing.hrs-piece}*{job_routing.QtyToMfg})/3600
-{job_routing.act-run-hrs}+{job_routing.act-setup-hrs}
Behind Hours
if {job_routing.end-date}< {?Cut off date} then
{@remain hours}
IP Logged