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
