Hi folks,
Hoping for some direction on what is the method to distribute Annual GL Line Budget values loaded into PQ across the months to which the Job Code is being budgeted. Could be between 1 - 12 months dependant on Job Start and End Month.
Data provided in attachment and example of required output.
Thanks for any assistance
Attached workbook contains one way to deal with it. The query is quite crude but works for a relatively straight-forward task like yours.
Since you seem to have the table with start and end dates in Excel, do yourself a favour and add a column that calculates the number of months like I did.
Hi Riny, thanks for your response - it works but for having an issue with one of the steps as explained in the attachment - Hoping you can assist to diagnose as it worked in your test file and i can't see where i've gone wrong
Thx
It's difficult to determine the cause of this based on a picture in a PDF only. Can you share the XLSX file, like I did earlier? Just for a few jobs including those that have dates that don't behave as they should. Remove any confidential information but leave the table structure and column names as they are.
