Hello All
I have a bespoke table that is linked to Job Tasks. This table contains many Job Task Numbers which may appear multiple times. Based on a Date Filter I need to find the last record for the task loop through all tasks finding the last record and sum up a value from each of the records.
The field that requires summing up is Earned Man Hours.
Thanks
Michael
Date
Votes
3 comments
-
Jet Reports Historic Posts hello wgk_jet,
"find last" depends on the key, that jetreport is using for this table or you have set in this jetreport.
So, what is the last one…last one, depending on a key with a date or depending on a key with an entry-no, or….?
reagrs
jetsetter -
Jet Reports Historic Posts Hi Jetsetter,
I have a single key "Job No.,Job Task No.,Effective Date" so it should find the last record for each Job No and Job Task No with the latest date and sum all the last values.
Thanks
Michael -
Jet Reports Historic Posts ok,
on which field depends the datefilter? on "effective date"?
when the job-no is in cell $d$2 (after find last) and datefilter is in cell $d$3
=NL("Sum";"TABLE???";"Earned Man Hours";"Job No.";$D$2;"effective date";$D$3)
does that fit for you?
Please sign in to leave a comment.