Ok
I have an if then else i.e. If SAP="Good" Then 1 Else 0
I then want to either Count or Sum this field and return the results which I am expecting but neither a sum or count works.
I then use a ToNumber formula then try the count/sum but it still does not work. Why can I not do something which is so simple when I have done this a million tiems before elsewhere?