Ok, so I'm going a little batty trying to finish a few reports before weeks end, so please excuse me if this sounds… err … remedial :)
I have a report that I'm pulling Job Ledger entries for employees that relate to their vacation. I'm rolling it up into a calendar view per employee (using simple excel calcs)
=NL("Rows","Job Ledger Entry",,"Resource Group No.","@@"&$F8,"No.","@@"&$H8,"Job No.","1-LEAVE HOURS","WBS",$C$2,"+Document Date","*")
Now, I need to pull information direct from the resource card (vacation entitlement, resource group - which I already have from the NL above) and employee card (employment date). I need them as fields which I will use to calculate further accrural information.
I can't for the life of me get the linkage to the employee and resource cards right so that I'm able ot pull this information for each employee (resource).
Make sense?
EssentiallY:
REs Group. No. Name J F M A M J J A S O N D Employment Date Vacay Entitlement
IT 037 Krista Swanson 0 0 0 0 0 18 0 0 0 0 0 0 0 Dec. 1 2008 120
Any help would make my day.
off to whack my head against a wall somewhere ;)
Krista