How to format at field to display absolute number

[rutgers]

I have one more question for you experts. I would like to format a field to display the absolute value of the number. For example, if it displays "4.5" I would like it to display "4".

Thank you again in advance!

 

[jdemmi]

You can create a formula like this


Abs({YourNumberField})

-- Jason
"It's Just Ones and Zeros

 

[rutgers]

Hmm, that didn't work for some reason. It is a field generated by a formula. Could that be why?

 

[jdemmi]

Abs(ToNumber({YourFormula}))

-- Jason
"It's Just Ones and Zeros

 

[jdemmi]

OH WAIT....I just reread your original post....ABS wll not solve your problem....the abs of 4.5 is 4.5

You need to display whole numbers, no decimals. Yes?

-- Jason
"It's Just Ones and Zeros

 

[rutgers]

Yes, I am sorry. I would like to display whole nunbers, with no decimals (and no rounding up or down).

 

[jdemmi]

//locates the decimal
numberVar x := instr(1,cstr({yourNumberField}),'.') ;
//moves 1 place before the decimal
numberVar y := x - 1 ;
//displays the left portion of the string up to the decimal
Leftcstr({yourNumberField}),y)

-- Jason
"It's Just Ones and Zeros

 

[jdemmi]

I noticed a typo in my post...


//locates the decimal
numberVar x := instr(1,cstr({yourNumberField}),'.') ;
//moves 1 place before the decimal
numberVar y := x - 1 ;
//displays the left portion of the string up to the decimal
Left(cstr({yourNumberField}),y)

-- Jason
"It's Just Ones and Zeros

 

[rutgers]

It worked!! Thanks a million!

 

[lbass]

I think you could just use truncate():

truncate({table.number})

-LB

 

[jdemmi]

True...and then modify the number formatting options to display no decimals...

Nice!

-- Jason
"It's Just Ones and Zeros