Expand my Community achievements bar.

Formatting Percentage in Calculated Custom Field from a Form

Avatar

Level 2
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
5 Replies

Avatar

Level 10
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

Avatar

Level 7
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

Avatar

Level 10
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

Avatar

Level 2
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

Avatar

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