Hello,
I am working on a scheduled script execution to determine the variance from last week's forecasted revenue, and actual revenue for the same period. I am attempting to populate a single score report with a percentage in a custom field (u_variance_percentage) for the aggregation average. I am querying the time_card table for total billable hours for the previous week, and the resource_allocation table for allocated hours during that period for my calculations. My calculations are somehow incorrect resulting in a negative result. I am uncertain of the issue causing this. Any help is appreciated!
