Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
Solved! Go to Solution.
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.
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.
| User | Count |
|---|---|
| 59 | |
| 47 | |
| 31 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 77 | |
| 66 | |
| 46 | |
| 22 | |
| 22 |