Hi. I'm encountering a problem with my formula for the column of one of my reports.
The condition should be, if the value is greater or equal than 8.5, then the value displayed should be 8.50, or else, if the value is less tham 8.50, it should retain the same value (e.g. If result is 4.00, the value displayed should still be 4.00)
I've been encountering errors with this formula. Can someone spot the problem? This was done under the Activity/Appointment module:
case WHEN "- Custom Number/Integer".S_NUM_1 >= 8.5 then '8.50' else "- Custom Number/Integer".S_NUM_11.00 end*