Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ???
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.
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.
Hi,
Check with it
=Num(count({<Q2LastYearScore = {1}>} responseid) /count({<Q2LastYearScore = {3}>} responseid),'###.##')
Celambarasan