I have a form where users enter the amount of work they have completed. Each type of work has an RE. E.g. An 'Enquiry' has an RE of 0.5 and should take 30 minutes to complete. I need the formula field to calculate the users output based on the RE, based on the number of 'Enquiries' they have actioned. i.e. 2 'Enquiries' should return "1".
My formula field (I've tried differences in the formula, but I'm more used to Excel):
(input.Enquiries * input.RE_Enquiry)
Error:
com.adventnet.ds.query.QueryConstructionException: Datatype [CHAR] of the column [t_1507429000000013081.Formula_1507429000000028346]
Both fields are set to Decimal.
Please help?