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.