Empty Field (HELP)

[rayscott]

I am using Crystal to connect to ADP software I am having a problem with one report. One field within the report is not showing a value for certian lines of the report and a value with others.
Example:

Name Gross Pay Tax Net Pay(formula field)

Bob 500 50 450
Jeff 440
Ed 200 25 175


I guess if it is not set up in ADP then the record for that field does not exist. Anyway when I create a formula field to add several fields, if that field is blank then it the result is blank.

Net Pay formula is:

Gross Pay - Tax


if the field has no value then the result will not.

i tried to set the field equal to zero by creating a formula that says:
if Tax >= 0 then Tax
else 0

that still resulted in a blank.

Do i need to use a variable or is there a way to force a value or something. If the field is blank then it should always be zero.

 

[cbarrol]

Try the isNull function. Maybe something like this will work:

If isNull (fieldname) then
fieldname = 0
If the field contains 0 rather tahn nothing, your total should be able to deal with it.

 

[rayscott]

Thank You Work Perfect