I believe that should be:
IF [triptype] = 'oneWay' THEN 1 END
After you create this field, double click on it to bring it on the view.
1. using table just count "number of record"
2. using formula
count([Number of Records])
count (if [Type]="one way" then [Type] end)
count_oneway-9.0.twbx 5.0 KB
Aren't you busy ??
Modify the calc to this...it might be a case of spaces
IF TRIM([triptype]) = 'oneWay' THEN 1 END
Wouldn't the number of records already tell me how many records there are for that trip type?