Forum Discussion
Solved
Time Comparison gives wrong answer
Hi, I'm trying to filter my data (telephone calls events) to only include calls that take place during work hours. Unfortunately the conditional statement I'm using returns the wrong answer from ...
az12 Can't replicate this. Try this though:
Call During Working Hours = IF( ('EVENT'[Local Start Time] - TRUNC('EVENT'[Local Start Time]) ) <= ('EVENT'[Working Day Closing Time] - TRUNC('EVENT'[Working Day Closing Time]) ),1,0)
1. Get rid of the EVENT text in your formula.
2. Make sure both your time columns are set to the same time format
This worked well for me: