Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
219
Views
Topic starter
Hello All,
Can you please help me with this
Value.Divide ([#"Time Spent#(lf)on Job#(lf)(Hours)"], 7.25)
No Syntax error is detected
However,
Expression.Error: We cannot apply operator / to types Text and Number.
Details:
Operator=/
Left=72
Right=7.25
Details:
Operator=/
Left=72
Right=7.25
The type of input column is ANY
Following is the data used
Time Spent on Job(Hours)
36
48
400
100
72
Thanks in Advance.
Faryal
Posted : 21/10/2020 9:51 pm
You can use
Value.Divide (Number.From([#"Time Spent#(lf)on Job#(lf)(Hours)"]), 7.25)
but better to format column as Integer or decimal before this operation, as it's more efficient to convert the column instead of converting row by row.
Posted : 21/10/2020 9:56 pm
