custom formula
-
Hello,
i have problems with a custom formula – i have 2 number-fields labeled with length and height – the values fromt he fields i want to multiply with each other ( to get square centimeters ) and muliply the result with different factors to get different prices the bigger the numbervalues are. This formula i have:
(({field.wcpa-number-1581519556001.value}*{field.wcpa-number-1581519634205.value})>500?({field.wcpa-number-1581519556001.value}*{field.wcpa-number-1581519634205.value})*10:({field.wcpa-number-1581519556001.value}*{field.wcpa-number-1581519634205.value})>1000?({field.wcpa-number-1581519556001.value}*{field.wcpa-number-1581519634205.value})*15:0)
when i enter numbers that result under 1000 then it works but if i enter numbers that result over 1000 then it still multiplys with 10 instead 15.
i set up the formula in a paragraph-field.greets Jan
The topic ‘custom formula’ is closed to new replies.