Increase font size of field value and field name (Formula-Numeric field with 2 decimal place percent value)

Question

I tried your solution to increase the font size of value a formula - numeric field is providing by using an additional rich text field and adding following formula:

"<span style='font-size: 24pt; text-align: left'>" & [my formula numeric field]*100 & "%" &" </span>"

I am able to increase the font size of my result. However, unable to keep the formatting intact to 2 decimal places as in my original fields. Any suggestions please?

Also, I want to increase the font size if name of this field. Any solution?

------------------------------
Neha Bansal
------------------------------

MarkShnierYou · Answer

Alas, I don't think that there is yet a simple way to get at those decimals. So we ten to squirrel away formulas for that purpose.

var number Value = Round([My numeric field],0.01) * 100; // this is here only because you say that this is a Percentage.
var text Decimals = "." & padright(Right(ToText(Int($value * 100)),2),2,"0");

var text Thousands = If($Value>=1000,ToText(Int($Value/1000)));

var text Hundreds=Right(ToText(Int($Value)),3);

var text NumberInTextFormat
IF($Value<0, "- ")
&
List(",",$Thousands,$Hundreds) & $Decimals)

"<span style='font-size: 24pt; text-align: left'>" & $NumberInTextFormat & "%" &" </span>"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community