Forum Discussion
Solved
Power Query Ignoring Decimals using Custom Column Formula
Hi Everyone,
Can someone explain this... I tried Editor as well to chagne the type to decimal but still having the issue where the calculations ignoring the decimals.
I am using this Custom Column Fromula and the expected result is 18.5 while I am getting 18.
if [Normal_Hours] = null or [Normal_Hours] = 0 or [OT_Hours] = null then
0
else if [Normal_Hours] + [OT_Hours] <= 10 then
[Normal_Hours] + [OT_Hours] +1
else
[Normal_Hours] + [OT_Hours]
Thank you in advance for your help.
It is sloved as my steps were not in order, I went back to Source and change data type to Decimal Type in advance Editor.
Tricky.
1 Reply
It is sloved as my steps were not in order, I went back to Source and change data type to Decimal Type in advance Editor.
Tricky.