Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi Deepak,
Thanks alot yar. Its working. once again thanks.
Sri