31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!
calculation only allowed if enough items entered
I want to calculation a Score with 7 items. Each item has 6 values (0,1,2,3,4,999). 999 is for not entered.
To calculate the score, 4 ore more items must be entered.
So I made a "help" calculation, which calculates how many items are not entered:
calc_missing func: ((Item1+Item2+Item3+Item4+Item5+Item6+Item7)/999)
for score calculation I used following funktion:
score func: decode(calc_missing,>3,999,(100-(((((Item1+Item2+Item3+Item4+Item5+Item6+Item7)-(999*calc_missing))/(7-calc_missing))*100)/4)))
the calculation works but >3 is ingnored...I found out that decode can't handle > or <
Now my question ist, how can I handle this problem without RuleDesigner?
Thanks for your help!