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:

"" & [my formula numeric field]*100 & "%" &" "

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
------------------------------

markshnier__you · 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)

"" & $NumberInTextFormat & "%" &" "

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

nehabansal · Answer

Thanks this helps. I created the below rich text field to increase the font size of the value :

"" & Round([My formular numeric field]*100,0.1) & "%" &" "

However, have few queries.

The result of 95.0 in my original field is getting converted to 95 in this new field. why?
Also, I want to increase the font size of name of this new field. Any solution?

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

markshnier__you · Answer

Sorry,&nbsp; but I am not understanding your most recent question.You asked a question and I suggested detailed code and then you did not use the code.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

nehabansal · Answer

I have not used the code you provided as I am not aware of where should I put that code. I am sorry to say but I am just a newbie to QB and not aware of any coding of the pattern you have mentioned.&nbsp;Should I pick your entire code and put that in formulas section of rich text field I have created?------------------------------Neha Bansal------------------------------

markshnier__you · Answer

yes------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

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

Related Content

Formula-Numeric Field Returning Null Instead of 0

Rate Increase

Rate Increase

Show Numeric Formula Field as Duration

Trying to format with 2 decimal places