Limit Char

[#1]

Hey hey,

basically i have :

=

count({<Q2LastYearScore = {1}>} responseid) /count({<Q2LastYearScore = {3}>} responseid)

in a text box, but want to limit the result to 2 decimal places, what is the best way to go about this ???

[swuehl · Accepted solution]

maybe

=num(

count({<Q2LastYearScore = {1}>} responseid) /count({<Q2LastYearScore = {3}>} responseid)

,'#.00')

or use one of the functions round(), floor(), ceil() with an appropriate base / step.

[CELAMBARASAN]

Hi,

     Check with it

     =Num(count({<Q2LastYearScore = {1}>} responseid) /count({<Q2LastYearScore = {3}>} responseid),'###.##')

Celambarasan