Login Page - Create Account

Support Board


Date/Time: Mon, 16 Sep 2024 19:10:06 +0000



Post From: Numbers Bars Calculated Values Text on Chart

[2024-06-26 18:29:14]
mandano89 - Posts: 24
Thank you for your help! It works with the following corrected formulas:

To show values above 30 and less than 0.7:
=AND(C >= C[-1], OR(ID2.SG45 < 0.70, ID2.SG45 > 30))

and

=AND(C < C[-1], OR(ID1.SG46 < 0.70, ID1.SG46 > 30))

It was important to add the OR function. Otherwise the number has to be smaller than 0.7 AND bigger than 30. This is impossible.
Another important aspect is that you have to checkmark "Use Full Precision" on the Alert.