Quirky Formatted Text / Duration Formula
Hello All,
I hope everyone had a great weekend. Wanted to bring something up to the group and wondering if anyone else has seen something similar:
I am currently taking a numeric field (Block Ho...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you adjust the formatting of the Block Hours field to expose more decimal places? Right now you are setting that field to display just 1 decimal. That way we can see what the real value is. Or perhaps you want to round that Block hours to one decimal before converting to HH:MM.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hi Mark,
Yes, we would prefer to keep the values rounded to the tenth. I believe it is a longer value and only displaying as one decimal point. However, I'm not sure why the numeric value would be anything other than down to the tenth - when I import the data it is rounded to the tenth.
------------------------------
Aidon Olligschlager |
Flight Operations Technical Support
Pentastar Aviation
Waterford MI
aolligschlager@pentastaraviation.com | 248-202-9587
------------------------------
Are you doing anything with the formula beyond just doing ToFormattedText with HHMM as the parameter? It might be a quirk with how QB does the conversion. Have you tried to parse it out yourself and just split it yourself to do the remainder * 6?
------------------------------
Chayce Duncan
------------------------------- MarkShnier__You
I'm confused.
You say this
"I believe it is a longer value and only displaying as one decimal point. "
Can you temporarily expose more decimals and post a screen show to prove that there is really only 1 decimal?
If there is more than1 decimal them you will want to round it to one decimal before converting to HH:MM format.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------So, I changed the decimal settings to floating point for demonstration: it's certain values when converting from a numeric field to a duration field using Hours( [Block Hours] ).
------------------------------
Aidon Olligschlager |
Flight Operations Technical Support
Pentastar Aviation
Waterford MI
aolligschlager@pentastaraviation.com | 248-202-9587
------------------------------You can round off the conversion with a round function, should resolve it for you.
Round([Block Hours],Hours(.1))
------------------------------
Chayce Duncan
------------------------------
