Calculation for Reports
I am trying to put a report together that counts the number of certain occurrences per field. I have a calculation field that looks like this;
If( Housekeeping = "Unsafe";
1 ; 0 )
Then I have a summary field that is a count of the calculation field. The problem is, when put into the fields into the report, the counts for "safe" and "unsafe" are the exact same, the numbers are off, but a select few actually display different numbers. Where could I be going wrong?