I've got a small formula that translates hours into (working) days...
The SQL will contain the data with decimal point... so for 80 hours it will come into crystal as '80.00'.
To remove the .00 I use a quick formula (called QTY Maths):
truncate({Time.HRS} / 8,0)
Next I work out if there are enough hours actually in the record to count a day or not, so use another formula...
if ({Time.HRS} > 8) Then
cStr("(" & truncate(
{@QTY Maths},0) & " Days)")
Else
"(Under a day)"
--------------
The above formula will output '(10.00 Days)'
Anyone have any idea why the truncate () isnt working?
I was expecting it to output (10 Days)