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

Created
October 08, 2021 23:10

Date Posted: 2014-05-05
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.