can anyone help with a formula issue I have with the app numbers
I am trying to do conversion rates for my team of workers on how their average weekly recruitment rate is.
so far so good but what I cant work out is how to remove the zero from the equation
the best way I can explain it is if a person isnt working on saturday their recruitment value is zero but as this is a weekly report the zero is calculated in the formula but then reports as an error and does not give me a true indication of their weekly efforts???
I am trying to do conversion rates for my team of workers on how their average weekly recruitment rate is.
so far so good but what I cant work out is how to remove the zero from the equation
the best way I can explain it is if a person isnt working on saturday their recruitment value is zero but as this is a weekly report the zero is calculated in the formula but then reports as an error and does not give me a true indication of their weekly efforts???