A field = 0 unless..

[Examinus]

Hello,

I current have a field (PaymentDaysOverdue) that I want to be set at 0, unless another field is filled in, in which case I want the field to be a calculation.

I currently have this:

If((DatePaymentRecieved=""); Get ( CurrentDate ) - DocumentsSentToZebra)

That works fine, and works out how many days a payment is overdue, but if DatePaymentRecieved is blank, the field PaymentDaysOverdue doesn't have any value.

I would like PaymentDaysOverdue to = 0 unless DatePaymentRecieved has something in it.

I've tried

If((DocumentsSendToZebra="...");0 or

If((DatePaymentRecieved=""); Get ( CurrentDate ) - DocumentsSentToZebra)

That put the 0 in if DocumentsSendToZebra is blank, but thenPaymentDaysOverdue is otherwise 1 no matter what the date etc is.

Any ideas?

Edited November 19, 2009 by Guest

[LaRetta]

Here is one approach:

[color:blue]Case (

NOT DatePaymentReceived ; 0 ;

DocumentsSentToZebra ; Get ( CurrentDate ) - DocumentsSentToZebra

)

At the bottom of the calculation dialog, uncheck 'Do not evaluate if all referenced fields are empty' and in Storage Option, check 'Do not store calculation results...'

[Examinus]

Many thanks - that works really well. :(