it works sir.the most important thing is, i got the idea of Cross apply.

Thank you sir.

I m just curious to know, in the future, the table will have more then...

• This reply was modified 5 years, 1 month ago by FKBEYS.
• This reply was modified 5 years, 1 month ago by FKBEYS.

Mr Steve, thank you for your help. it works great.

Thank you for your help Mr. Brian

there are 10 discounts. So it would be hard to write a function. so that i m trying to find a way to do...

• This reply was modified 5 years, 1 month ago by FKBEYS.