Formatting Percentage in Calculated Custom Field from a Form

[LadellFu]

Hi, We have calculated custom fields in one of our forms. An example of the calculation is DIV({Clicks},Impressions) . When pulling the field into a report, the calculation works. However, we want to format the field and/or column so it show percentage instead of a regular number. Is there a way to do this in the custom form in the calculated field? Thanks for help in advance!!! Ladell Fuqua Condé Nast | PubWorx Services, LLC

[VicAl]

I believe you can just use: valueformat=asPercent Vic Alejandro, PMP, CSM | IT | Sr. Technical Project Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

[TerryHy]

Hi Ladell, I am by no means an expert with expressions, so I am hoping this is correct. In order for it to represent percentage, I believe you need to add *100 to your calculation. As in DIV({Clicks,Impressions)*100 If you want to round it to the nearest percent, then you would need to use the ROUND expression and add 2 at the end. As in ROUND(DIV({Clicks,Impressions)*100,2) Terry Hynd EBSCO Information Services

[VicAl]

Just to be more clear, you would put this value format in your display field (in your report or view (not in the form itself)). Let me know if you want me to expand more. I never know how much detail to add here as everyone's experience is different. Vic Alejandro, PMP, CSM | IT | Sr. Technical Project Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT

[LadellFu]

Thanks Vic... I tried to override valueformat=customNumberAsString with valueformat=asPercent in the report and it didn't work. Then I tried to add it in the custom form calculation, but couldn't find a way to do it. Thanks for your help! Ladell Fuqua Condé Nast | PubWorx Services, LLC

[LadellFu]

Thank you Terry and Vic!!! It worked and we're on our way. Have a great weekend! Ladell Fuqua Condé Nast | PubWorx Services, LLC