Forum Discussion
IF Statement Help
Have you tried simply reversing the logic to remove any decimal issues that might be occuring?
xMeasure = IF(Employee[Duration] < 8, Employee[Duration]/8, 1)
I would assume since you are calculating the hours that somewhere a calculation is continuing into decimal places that are hidden.
Based on this, I did go back to the start. I decided to make a new calculated column that does nothing but takes the Employee[Duration] column and divides by 8. Low and behold a discrepency developed. Digging a bit further, I found that for every employee that simply clocks in followed by a clock out at the end of the day (meaning no break in between), the IF statement works fine. However, for the employees that are following the rules (a discussion for another forum) and clocking in in the morning, clocking out at lunch, clocking in after lunch, and clocking out at the end of the day (so - two time entries per day), the formula wasn't working.
The way the two times were being aggregated was by simply removing the two columns. So, I DO need to go back and look at that Employee[Duration] column formula and getting a little more specific on it.
I'll start another thread if I need help with that one.