5 Replies Latest reply: Oct 27, 2013 10:48 AM by Gysbert Wassenaar RSS

    Calculated Condition - multiple criteria's

    Steve Zagzebski






      I have a chart that I need to have a calculated condition on.


      The calculated condition has to use the fields above and address the following:

      1. Year, Month and Product must have a selection BUT only 1

      2. The variable vRetained must have an amount and it must be something less that 100%

      3. There can be NO OTHER selections made from any of the other fields


      Are the 3 critieria above possible using the Get function? I am struggling...


      Lastly - I doubt this is possible - but can the error message tell the user which of the above are not met.


      Thanks in advance for any help,