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

    Calculated Condition - multiple criteria's

    Steve Zagzebski

      Fields:

      Year

      Product
      Month

      VRetained

       

      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,

      Steve