Skip to Content
0
Former Member
Jan 03, 2008 at 01:47 PM

Rounding values in a cross tab

26 Views

Post Author: hj1972

CA Forum: Formula

I have a cross tab which is returning the number of children in certain categories (done by counting the unique child_code on each child record). For disclosure reasons the results need to be rounded to the nearest 5. Any ideas on how to do this is in a cross tab? I can round to the nearest 10 by using 'format field' and customise but can't get it to the nearest 5.