Help with Variable

[hopkinsc]

Hi, i need some help setting up an input box.

i currently use the following expression in a straight table..

Round(If ([Deal Description] = '12721 - LUNCH TIME DEAL £3' or [Deal Description] = '200030 - LUNCH TIME DEAL £3' ,Sum(InDealQuantity)/3, Sum(InDealQuantity)/2))

Which basically divides the InDealQuantity for the specified deals descriptions by 3, any other DealDescriptions are divides by 2.

I want to try and have an input box instead where the user chooses the deal, then enters a 'Qty' instead of it being hard coded like above.

My fields are:

InDealQuantity = items sold as part of a deal

I have set up a variable

vTriggerQty

but i don't know what to do on the variable trigger..

Can anyone help?

I have attached a sample

[SunilChauhan]

see the attached file

hopee this helps

[hopkinsc]

Hi, thanks for your reply, although that's not what i wanted.

I have managed to get it working now though, i changed the expression to:

Sum(InDealQuantity)/vTriggerQty

All other variables i have used in the past have needed triggers to be set up, this was one of the easiest

Thanks