Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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?
Thanks
dude copy the exactly same code which i posted earlier. ok
Regards,
Shumail
Use the else condition simple
If ([Deal Description] = '900000 - P5-P8 MEAL DEAL £3' ,Sum(SalesQuantity)/3, Sum(SalesQuantity)/2)
Regards,
Shumail Hussain
Thanks for your reply, But where would i use the ELSE condition.
I have tried copying exactly whats in your example, and tried putting else before the second sum, but it doesn't work??
dude copy the exactly same code which i posted earlier. ok
Regards,
Shumail