FredP Posted June 11, 2008 Share Posted June 11, 2008 Hey I have a field that calculates a percentage, and it returns .01 for 10%, .02 for 20%. id like to do an adjustment on the result so it displays in percentage. It will need to be able to show a percentage over 100%, ie: if the decimal is .12, the result would be 120% Anyone have ideas? Link to comment Share on other sites More sharing options...
FredP Posted June 11, 2008 Author Share Posted June 11, 2008 Doh! I just found this posting that explains its just a field number format issue. Just display the number as a percentage! Thanks! Link to comment Share on other sites More sharing options...
David Head Posted June 11, 2008 Share Posted June 11, 2008 Hey I have a field that calculates a percentage, and it returns .01 for 10%, .02 for 20%. id like to do an adjustment on the result so it displays in percentage. It will need to be able to show a percentage over 100%, ie: if the decimal is .12, the result would be 120% Methinks your maths is not quite right there: .01 = 1% .02 = 2% .12 = 12% 1.2 = 120% Link to comment Share on other sites More sharing options...
FredP Posted June 11, 2008 Author Share Posted June 11, 2008 i was going to fast.... But of course,you are right.... My fingers where typing faster than my brain could correct. thanks Link to comment Share on other sites More sharing options...
David Head Posted June 11, 2008 Share Posted June 11, 2008 OK, have a look at this post then: Slow down... Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts