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
A simple way would be just doing [Decimal Field] * 100. That would get you back to the percentage you are wanting and then just make sure the field only shows 2 decimal places. Not sure if that would work for all your data but I think it should. Definitely test it.
When I try to * 100 the result is just 0.
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
- Where you are trying to do this? Is this in a new field that takes the completed decimal and then multiplies it by 100? Or are you adding this to a formula somewhere? If adding to a formula please post the formula.
- 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
------------------------------- 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?