Trying to do a simple expression which seems to be straight forward in the appsheettraining samples and training. Need to calculate the price for a task: [Hours] * [HourlyRate]. However, I'm getting "has an invalid operator" error. Hours are calculated for "duration": ([EndTime]-[StartTime]). When I change from duration to decimal, the price error goes away, but get "app formula 'Duration' does not match the column type"; the same if using "number". All of this particlar work is on the same table.
Solved! Go to Solution.
A Duration is not a numeric value. You'll need to use TOTALSECONDS(), TOTALMINUTES(), or TOTALHOURS() to convert a Duration value to a numeric value.
A Duration is not a numeric value. You'll need to use TOTALSECONDS(), TOTALMINUTES(), or TOTALHOURS() to convert a Duration value to a numeric value.
Thank you
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |