Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago

Formula Change from Decimal to Percentage

Hey Everyone, This is a Rich Text field. I'm working on a formula that takes a field and adds some styling to try and make the field larger while being highlighted based on its value. I've been ...
Formulas and functions
AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago
Switching to & worked. I had to keep the ToNumber as I had to use the Left()ToText() to only get XX.XX digits before adding the "%".

Thanks for all your help Austin! I now have the Accurate 28.13% allowed to be highlighted to show importance as well!

Thanks again!

------------------------------
Alex Bennett
------------------------------
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Rather than having to convert the number back and forth between Numeric and Text, you can also use the Round function:
var number margin = Round([Total Job Gross Margin F]*100,.01);

If( $margin >= 0 , 
"<span style='background-color:#fbff00; font-size:16px; font-weight:bold'>" & $margin &"%</span>",
"<span style='background-color:#ff0000; font-weight:bold'>"& $margin & "%</span>" )​


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------