Forum Discussion
Rolling Hours by week
I've created this matrix showing client name in the rows, total weekly hours billed by relative date filtering (most recent including today) in the last 60 days sorted by the client with the most hou...
Hi Jay.....I explain item #2 as follows:
- In the illustration below I would need to insert a column at the far right that would calculate the difference between the hours (first row 6,509) for, in this case the most current week (column “March 6, 2020) minus the hours (first row 6,021) for the week prior (February 28, 2020) giving a result of a variance of +488 and so on for each row and highlight the results that fall into negatives.
Does anyone have a solution to the above issue? Would greatly appreciate any help on this.