3 Replies Latest reply: Jul 24, 2010 10:48 AM by Shumail Hussain RSS

    adding 2 different calculations to expression

    Chris Hopkins


      I need to do the following...

      I have a LIST BOX which displays various DEAL DESCRIPTIONS. Linked to these DEAL DESCRIPTIONS are Sales quantities.

      I have created an expression which divides the Sales quantities by 3 when a specific DEAL DESCRIPTION is selected.

      This is my expression

      If ([Deal Description] = '900000 - P5-P8 MEAL DEAL £3' ,Sum(SalesQuantity))/3


      But i need to divide any other DEAL DESCRIPTION by 2.

      The reason for this is that the above DEAL DESCRIPTION incorportaes 3 products. But all other DEAL DESCRIPTIONS only incorporates 2 products,

      Does anyone know how i would include this in my expression?