Expanding Group Decimal Points CR v8.5

[AlohaMichael]

This is related to topic # 767-878823

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/100/pid/767/qid/878823

I want to be able to group on the Integer portion and have all of the related documents listed underneath.

for example
+17.000
17.001
17.002
17.005
17.006

but CR is showing it as
17.00
17.00
17.00
17.01
17.01

Any suggestions / ideas?
Most appreciative

 

[lbass]

I was having the same trouble you are with the val or tonumber function rounding the formula to 2 decimals--even though I thought I had formatted the formula by going to format field->number->customize->decimals->1.000->rounding->0.001. Anyway, it now seems to be working using the following for the sort formula and the previous format settings:

val({table.string})

If you want to display the original string field, add a second formula to the sort list which sorts by the letter that sometimes ends the string field (from your other post):

if not numerictext(right({table.string},1)) then right({@string},1) else ""

For the group field, use:

val(left({table.string},instr({table.string},".")-1))

-LB