I’m trying to show response rates as a percentage with 3 decimal points (xx.xxx%) but it seems no matter what I try it’s only showing 2 (xx.xx0%).
Calculated fields:
{submitted}/{mailed}; {settled}/{mailed}
Attempted:
- Change decimal places in number format
((1000000*{submitted})/{mailed})/1000000((123456*{submitted})/{mailed})/123456-
{grr_div} = ((1000000*{submitted})/{mailed});{grr} = {grr_div}/1000000 -
((999999*{submitted})/{mailed})/1000000(just to see) - Compute values at query level (precision is kept there but lost on import)
It does show all the precision I need when I multiply by 100, but then I can’t show it as a percentage less than 100%. The root cause is that QS only keeps 4 digits of precision after the decimal point - displaying as a percentage does not evaluate differently, it only changes the number format. I need to find out if there’s a way around this limitation.
Possible solutions:
- Find a way to keep precision
- Express values > 1 as direct percentages
