[RESOLVED] CR 11... format a number in a formula field?

[Besoup]

hello,
I have a number displaying from a formula field. The reason I put it in a formula field is because I needed to add a "-" before it. My problem is that the number displays "-5.00". I need to know how to get rid of the decimal fomatting in a formula field...

Anyone have an idea?

[King_George]

hello,
I have a number displaying from a formula field. The reason I put it in a formula field is because I needed to add a "-" before it. My problem is that the number displays "-5.00". I need to know how to get rid of the decimal fomatting in a formula field...

Anyone have an idea?

I haven't used CR11 yet, but does it allow you to right-click the formula field on the form and then select format from the popup menu?

If it does then choose format -> Numbers -> custom format and do whatever you please.

HTH

[Besoup]

I haven't used CR11 yet, but does it allow you to right-click the formula field on the form and then select format from the popup menu?

If it does then choose format -> Numbers -> custom format and do whatever you please.

HTH

yeah you can right click and format field but there is not number formatting in the format box.

die crystal! :P

[ducky]

I'm guessing in your formula was interpreted as a string now because you added the "-" in the formula by using a string concatenation like "-" & yournumber. You need to create a formula that retains being a number and then you can still format it. Try changing your formula to be -1 * yournumber (to get the negative in front) and then when this formula is placed on your report it is still considered numeric and can be formated to not display the decimals.

[Besoup]

I'm guessing in your formula was interpreted as a string now because you added the "-" in the formula by using a string concatenation like "-" & yournumber. You need to create a formula that retains being a number and then you can still format it. Try changing your formula to be -1 * yournumber (to get the negative in front) and then when this formula is placed on your report it is still considered numeric and can be formated to not display the decimals.

tried :

-1*{PO_Header.PO_Header_Draw_Number}

and still got the same result =/

[Besoup]

nvm, now I can format the field like it is numeric... thanks!