Hello Michaël,
var a = @number field A;
var b = @number field B;
a != null && b != null ? 40 : a != null || b != null ? 20 : 0
Rainer
Post
Follow
if number field has a value show a number.
Hi,
I'm using two number fields and one calculation field.
In my calculation field I would like to get a number 20 or 40 if one or both number fields are filled in.
How can I translate this into a code that my calculation field will understand?
by example:
number field A: has a value = calculation field: 20
number field A & B : has a value = calculation field: 40
kind regards,
Please sign in to leave a comment.
2 comments
Hi Rainer,
thanks for the fast reply.
Kind regards,