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
How would you write the code to limit the decimal to 2 using a rich text formula?
------------------------------
Barry Dolan
------------------------------
------------------------------
Barry Dolan
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI 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
------------------------------
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
------------------------------