This content has been marked as final. Show 3 replies
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?