kept on getting the specified field cannot be found.
When i keyed in the formula in my calculation,
Sum((Rooming Type)= single)
it kept on having the the specified field cannot be found for single.
I checked and the single field format is text.
Is there a solution to this?