I have this float column with following values

 

Data in db          Like to display 
                          using my formula      but Crystal will display

=======          ===========        ============

 

14                      14                            14.0000     

14.1                   14.10                       14.1000

14.12                 14.12                       14.1200

14.123               14.1230                   14.1230
14.1234             14.1234                   14.1234

14.12345           14.1234                   14.1235

 

and I have tried this formula using the decimals field from number tab
but it doesn't seem to work, the only thing seems to work is the 'else 4'

 

I'm not sure what's missing, thanks in advance for the help

 

if {table1.column1} = 0

   then 0

else if {table1.column1} = 1

   then 2

else if {table1.column1} = 2

   then 2

else

   4

                   
TT

 

 

 

 

You helped me last time with that formula, from the result of the len, you can then use that number for the decimal, it worked perfectly.

 

I was just wondering, why when using the formula directly against the column it didn't work, or only worked with the portion 'else' at the end and nothing else above that

 

anyway, thanks again

 

TT

 

 

 

Yes it helps

 

I see what you mean now, for some reason I though the 'if {table1.column1} for that particular instance was referring to the number of digist after the dot, it wasn't, it referred to real value of that column then for sure, it's almost alway 4

 

Thanks very much for your time Ryan

 

TT