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
but when I look at the overall figures it is completely wrong
Any clue as to what I am doing wrong. I have checked the data types etc and each one is num