Limiting multiple decimal points
I am creating a summary report to track an average number related to a field (# of days since the customer was last contacted). I was able to create the report without issue but the averages that are ...
Forum Discussion
You have not said what field type this is. If it is a numeric field type, then typically when you set the number of decimal places to 0 (zero) then it will respect that setting.
If this is a duration field type, and it is not respecting the number of decimals, then a work around would be to make a new field which is a numeric field with the formula
ToDays([My Duration field]) and set the number of decimals at zero
If this is a duration field type, and it is not respecting the number of decimals, then a work around would be to make a new field which is a numeric field with the formula
ToDays([My Duration field]) and set the number of decimals at zero
- How would you write the code to limit the decimal to 2 using a rich text formula?
------------------------------
Barry Dolan
------------------------------- MarkShnier__You
Qrew Legend
I have a variety of formulas, see if this one works
ToFormattedText([Price],"comma_dot",3) &
If(
not Contains(ToText([Price]),"."),
".00",
Length(Right(ToText([Price]),"."))=1,"0"
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Good to know, I'll keep these for future reference. I was actually able to resolve my issue using a Round function.
Sometimes the hardest issues have the easiest solutions.
Thank you
------------------------------
Barry Dolan
------------------------------
