I want to subtract two date fields in Tableau and find the difference in terms of days, rounded to two decimal places. I have already created a calculated field, however the result is rounded down to the nearest whole number.
The current calculated field I have is such:
DATEDIFF('day', [Reg Time], [Valid Time])
Which returns a result as such:
Reg Time | Valid Time | Datediff
11/1/2018 12:00 AM 11/1/2018 1:00 PM 0
What I want is this:
Reg Time | Valid Time | Datediff
11/1/2018 12:00 AM 11/1/2018 1:00 PM .5
The datediff would return a result of 0.50 because the difference is 12 hours(half a day)
All help is greatly appreciated.