Overall Percentage wrong

Hi all,

I have a google sheet which has many names within it. Each name has a number of days missed (days stripped) and also how many of these days are (Fri Absences).

I have created a claculated field to work out, as a percentage, the fri absences as opposed to the overall days missed. This works on and an individual basis when I click on a particular name
Kcops_0-1704621067920.png

but when I look at the overall figures it is completely wrong
Kcops_1-1704621144330.png
Any clue as to what I am doing wrong. I have checked the data types etc and each one is num

 

 


  

0 0 51
0 REPLIES 0
Top Labels in this Space