Forum Discussion
BarryDolan1
5 years agoQrew Member
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
5 years agoI 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
------------------------------
- BarryDolan15 years agoQrew MemberGood 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
------------------------------