Custom Field Formula

[Danny]

I am attempting to use a formula in a custom number field to decide whether
the field should be blank (not even showing a 0) or allowing a percentage
number to be entered.

I think that I should use IIf( [Estimate Type] = 2OR 3, " ", falsepart ) . I
am not sure how to complete this

Is this possible in a number1 field or do I need to use a text field? If so,
then what should I use as a fomula. Obviously, I am not a coder/programmer,
so any help would be greatly appreciated.

 

[John]

I am attempting to use a formula in a custom number field to decide whether
the field should be blank (not even showing a 0) or allowing a percentage
number to be entered.

I think that I should use IIf( [Estimate Type] = 2OR 3, " ", falsepart ) . I
am not sure how to complete this

Is this possible in a number1 field or do I need to use a text field? If so,
then what should I use as a fomula. Obviously, I am not a coder/programmer,
so any help would be greatly appreciated.

Danny,
To answer your first question, no it is not possible to use a spare
number field for a couple of reasons. First, spare number fields will
always have a value, whether it is "0" or some other integer or floating
point number. Second, spare number fields do not allow "%" characters
although it could be entered in decimal form.

OK, now here's something I don't understand. If the custom field you
have renamed as "Estimate Type" has "20R 3" in it, you want the new
custom field to be blank. Otherwise, you want to enter a percentage
value. Why not just look at the Estimate Type field and then enter the
percent value? A formula will do nothing for you since it will "put" a
blank in an already blank field cell and you will still have to
physically look at the Estimate Type field to know whether to enter a
percent value. I must be missing something.

John
Project MVP

 

[Jack Dahlgren]

John brings up a good question. You should be aware that a custom field can
have EITHER a formula (which returns a value - even a blank value) or a value
which you input. It can't have both. You can't just type data into a custom
field with a formula.

If you can explain what it is you are trying to achieve (rather than how you
are trying to achieve it) then we can probably give you some suggestion about
how to do it. The way you are working now doesn't seem like a good direction.

-Jack Dahlgren

I am attempting to use a formula in a custom number field to decide whether
the field should be blank (not even showing a 0) or allowing a percentage
number to be entered.

I think that I should use IIf( [Estimate Type] = 2OR 3, " ", falsepart ) . I
am not sure how to complete this

Is this possible in a number1 field or do I need to use a text field? If so,
then what should I use as a fomula. Obviously, I am not a coder/programmer,
so any help would be greatly appreciated.

Danny,
To answer your first question, no it is not possible to use a spare
number field for a couple of reasons. First, spare number fields will
always have a value, whether it is "0" or some other integer or floating
point number. Second, spare number fields do not allow "%" characters
although it could be entered in decimal form.

OK, now here's something I don't understand. If the custom field you
have renamed as "Estimate Type" has "20R 3" in it, you want the new
custom field to be blank. Otherwise, you want to enter a percentage
value. Why not just look at the Estimate Type field and then enter the
percent value? A formula will do nothing for you since it will "put" a
blank in an already blank field cell and you will still have to
physically look at the Estimate Type field to know whether to enter a
percent value. I must be missing something.

John
Project MVP