Formatting Percentage in Calculated Custom Field from a Form

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

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

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

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

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