Nikesh Valji
New Member
Hi All,
I have managed to create a powerpivot workbook to reconcile the hours posted by engineers working on recoverable projects. The hours are derived from two distinct systems, one from our General Ledger system (i.e. SAP) and the other from our dedicated Timesheet system. The common denominator is the Project Code which can be found in both and I have managed to calculate the delta using the "New Measure" functionality.
However I would now like to apply a monetary value to the hours delta as each project has a recoverable rate although I am having trouble trying to get the syntax right.
Any help would be greatly appreciated.
The file is too big to upload so if you have any questions please advise and I will answer as best as I can.
Many thanks in advance,
Nik
I have managed to create a powerpivot workbook to reconcile the hours posted by engineers working on recoverable projects. The hours are derived from two distinct systems, one from our General Ledger system (i.e. SAP) and the other from our dedicated Timesheet system. The common denominator is the Project Code which can be found in both and I have managed to calculate the delta using the "New Measure" functionality.
However I would now like to apply a monetary value to the hours delta as each project has a recoverable rate although I am having trouble trying to get the syntax right.
Any help would be greatly appreciated.
The file is too big to upload so if you have any questions please advise and I will answer as best as I can.
Many thanks in advance,
Nik
