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!