December 13, 2021
July 16, 2010
Welcome to our forum. The total is taking the sum of the daily rate x the sum of the working days, rather than the sum of the normal rate. This is by design. If you want it to sum the normal rate then you can either add the 'normal rate' field to your source data rather than as a calculated column, or you can use Power Pivot and a DAX measure.