AnsweredAssumed Answered

If statements

Question asked by underthepump27 on Jul 3, 2014
Latest reply on Jul 8, 2014 by underthepump27


If statements


     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)


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


     If (Terms; 'prepaid'; 0)


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


     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.