Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
vYear which hold values on the basis of year selection by user like 10,11,12,13,14,15,16...from list box
vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7 are variable which holds different values.
requirment is like if vYear=10 then vValue1 ,if vYear=11 then vValue2 ,if VYear=12 the vValue3
I tried with pick, Pick(vYear,vValue1,vValue2,vValue3,vValue4,vValue5,vValue6,vValue7)
but did not work , any other way to do it.
Try vYear - 9:
pick(vYear - 9,vValue1,vValue2,...)