### Title

If statements

### Post

Hi there, if someone could help me it would be greatly appreciated. I have had a look through the knowledge database but to no avail.

I am trying to get a numerical value from a value in a field.

Unfortunately I get a ;one' if the field is occupied, and 'zero' if the field is empty.

The if statement is as follows-:

If (Terms; 'Nett 7 days'; 7)

or

If (Terms; 'net 14 days'; 14)

or

If (Terms; 'prepaid'; 0)

or

If (Terms; 'C.O.D'; 0)

or

If (Terms; 'Nett 30 days'; 30)

The calculation result is set to number and the number of repetitions is set to 5

Any help would be greatly appreciated.

I'm guessing you're defining a calculation field ? If so:

Case(Terms = "Nett 7 days" ; 7;

Terms = "Nett 14 days" ; 14 ;

Terms = "Nett 30 days" ; 30 ; 0 )

which is basically saying If Terms = 7, 14 or 30 set the calc field to the correct number, otherwise set it to 0