Re: Formula Change from Decimal to Percentage
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?
Forum Discussion
9 Replies
- 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
------------------------------
