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 ...
Forum Discussion
I create a new formula and tried both in a text formula (since original is rich text) and say [Total Job Gross Margin RT]*100, as well as just ToNumber([Total Job Gross Margin RT])*100 for formula - currency to test and try to get that number with the same styling converted to decimal
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
Take what is in the field [Total Job Gross Margin F] and use that for the calculation instead. That is where the number comes from, correct?
- Correct, but the styling is taking that field to allow highlighting [Total Job Gross Margin RT]
------------------------------
Alex Bennett
------------------------------- UPDATE: I changed the formula to *100 and it now displays as 28.134877
is there a way to only show 28.13, as well as adding a percent symbol?
------------------------------
Alex Bennett
------------------------------- Any suggestions on the percent sign? I changed the code to:
ToNumber(Left(ToText([Total Job Gross Margin F]),6))
So now my result is 28.13
------------------------------
Alex Bennett
------------------------------