Rounding a summary field

[indy4300]

I am trying to Round Up
to 5 different sizes In one summary field how do I do this
85_96" = 96"
97"_108" = 108"
109"_120= 120"
121_132" = 132"
133_144" = 144"

 

[comment]

It seems you want to do simply:

Ceiling ( YourField / 12 ) * 12

You didn't say what should happen when the value is 84 or 145, so that's a guess.

 

Edited June 1, 2016 by comment

[Lee Smith]

I remove the replies to the other topic.

Lee

[indy4300]

Hi Lee Thank you so much it works perfect and so simple

Greg