I have a formula field to display hours of meetings called (Meeting_Durations_Hours__c). Since there are meetings with many durations I want to segment the durations Ex: 0-2 hour, 2.1-4 hour likewise. Whole purpose of this is to group the meetings by these segments in the my standard report for meetings. I tried bucket field in stndrd reports but it wont automatically do this as we have to add values manually to each created bucket field.
So I created a Text formula field for hour segments called (Meeting_Durations_Hours_Segment__c)
Meeting_Durations_Hours__c is also a Text Formula Field.
and I want to do something like this :-
IF((Meeting_Durations_Hours__c ), <0,"Less than a hour", 0>3, "0-3 Hours", 3>5, "3.1-5 Hours", 5>10, "5.1-10 Hours", "None")
But it's displaying an error:-
Error: Incorrect parameter type for operator '<'. Expected Text, received Number
How can I do this ?