Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoAlas, 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
------------------------------
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
------------------------------
NehaBansal
5 years agoQrew Member
Thanks this helps. I created the below rich text field to increase the font size of the value :
"<span style='font-size: 24pt; text-align: left'>" & Round([My formular numeric field]*100,0.1) & "%" &" </span>"
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
------------------------------
"<span style='font-size: 24pt; text-align: left'>" & Round([My formular numeric field]*100,0.1) & "%" &" </span>"
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__You5 years ago
Qrew Legend
Sorry, 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- NehaBansal5 years agoQrew MemberI 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.
Should I pick your entire code and put that in formulas section of rich text field I have created?
------------------------------
Neha Bansal
------------------------------- MarkShnier__You5 years ago
Qrew Legend
yes
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------