Hi Team,
I need to calculate the below using loops.
I have a table "Ticket" holding the number of tickets against dates. Need to calculate the cost for the below range of ticket count.
Min Count of Tickets |
Max Count of Tickets |
Amount to be charged in dollars |
1501 |
1750 |
500 $ |
1751 |
2000 |
550 $ |
|
for every additional range of 250 tickets |
90 $ |
Up to 2000 ticket count, the cost is fixed. Post 2000 ticket count, addition of 250 tickets to be charged 90.
Example:
Count of ticket |
Price |
1569 |
500 $ |
2000 |
550 $ |
2249 |
550+90 $ |
2500 |
550+90+90 $ |
Regards,
Hitha Dhani