Search results for query: *

No I do not need to bring YTD figures into the report, I can just filter on the accumulator codes for sick time but have the period YTD rather than just for the period of the rest of the report. I hope this makes sense :) Thanks, LL

With the exception of the YTD column all other columns will have data that corresponds to the same period. I was thinking I would add a parameter to the employees {SHIFTDATE} for the period I'm looking at. Thanks, LL

I will need those accumalator codes elsewhere. Here is how the report should look when I am done The first sort needs to be by department then employee Here is the layout of my columns Department Name/ Employee Name/ Sick Incidents/ Worked Hours/ Sick Hours/ YTD Sick Hours...

Thank you that is working but how do I exclude {PAYIHIST.ACCUMCD} codes that I do not want. Thanks LL

I should clarify {PAYIHIST.ACCUMCD} has many different paycodes and depending on the paycode {PAYIHIST.AMOUNT} may either be a count or hours. Here is a brief discription of what is in the tables For example {PAYIHIST.ACCUMCD} {PAYIHIST.AMOUNT} Employee 1 SINC...

Hi I have a table called PAYIHIST. In one column I would like to report the sick incidents for each employee so I created a formula: if {PAYIHIST.ACCUMCD}= 'sinc' then {PAYIHIST.AMOUNT} In the next column I would like to write another formula that pulls that employees worked hours in their...