Hi all, I try to calculate this value in a formula:
if (selection 1 + selection 2 - selection 3 <0)
return 0
else
return (selection 1 + selection 2 - selection 3)
I tried this but doesn't work. how we declare return value? when I try return 9 value with *9 statement, the value is multplied with 9...
(( '0deb_cre_lc' + '0deb_cre_lc' - '0cre_lc' ) < 0) * 0 + (('0deb_cre_lc' + '0deb_cre_lc' - '0cre_lc' )>= 0) * ( '0deb_cre_lc' + '0deb_cre_lc' - '0cre_lc' )