I have a table with calculated fields. I did the math manually and it matches an excel spreadsheet I used to validate totals but inside the table it’s not calculating right. In the example of data in the table the calculated field is for Hours. (Hours = (8-(8*.123)) * ‘Scrum Team Issues by Month’[Total Networking Days] * ‘Scrum Team Issues by Month’[Head Count] * ‘Scrum Team Issues by Month’[Allocation %])
In example row 1 it should be 75 hrs not 71. Do you have any idea what could be causing that?
The Allocation % is a calculated field taking the row level story points and dividing it by the total scrum teams monthly total points. That % is correct in the table.