Input box

[#1]

Dear All,
i want this in pivot chart expression (Distance * 12* one tonne) = am clear in that.
but my prob is..

distance * 12 * Balance tonnes

variable for 12 as an input box...

keep 12 default... but let the user key in a figure say 14 then the Transpoert cst would be = distance *14 * tonnages

before that am not using input box plz help me as soon as possible.

Thanks in advance

Regards,

Sri

[deepakk]

HI,

Create a variable vValue and use it in Inputbox.

Replace the 12 with vValue in the expression.

distance * vValue * Balance tonnes.

You have to type 12 in the input box for the first time.

[#3]

Hi Deepak,

Thanks alot yar. Its working. once again thanks.

Sri