Date Posted:
Product: E-Notebook Enterprise
Product: E-Notebook Enterprise
Problem:
I have setup color formatting for a calculation field in Bioassay. Issue is that colors shown are not correct. Example:
1- Values greater than 0 should red.
2- Values greater that 10 should be yellow.
3- Values greater than 20 should be green.
When calculated value is 15, color shown is red when it should be yellow.
Solution:
The order of the coloring conditions is relevant in Bioassay. The resulting color is going to be that of the last true condition. In the example, if condition 2 is above condition 1 this is what happens:
Bioassay evaluates condition 2 (15>10) -> true->yellow, but then it evaluates condition 1 (15>0), which is also true ->red. Bioassay will show the color of condition 1, which was the last true condition.