Support Board
Date/Time: Fri, 27 Dec 2024 11:20:59 +0000
Post From: AND FUNCTION NESTING
| [2015-12-08 03:57:08] |
| AP - Posts: 117 |
|
If using the AND() function for chart alerts - I see that nesting and AND() withing another AND() is not working. For instance - I was using - =AND(ID2.SG1>0,AND(id5.sg1<id5.sg4,C<ID17.SG1)) and clearly it gives effect to the first 2 expressions but not to the last one when firing alerts - e.g. C<ID17.SG1 condition is not fulfilled while firing that alert - qs - 1. is nesting allowed in such cases? 2. is there a work around? 3. am I using the above condition rightly in the first place? |