Hi I want to create a column or measure that will help me calculate how much a parking session is.
Below is my tariff rate table.
Example I may have a customer who parks in zone AA on a Monday between 10am till 18pm. I want to use the below tariff rate table to calculate how much this parking session will cost me.
| | | | Tariff Start | Tariff End | Tariff Start | Tariff End | Tariff Start | Tariff End | Tariff Start | Tariff End | Tariff Start | Tariff End |
| Zone | Cost of one hour staff parking | Cost of one Min | Monday | Monday | Tuesday | Tuesday | Wednesday | Wednesday | Thursday | Thursday | Friday | Friday |
| A | £3.00 | £0.05000 | 08:30 | 19:30 | 08:30 | 19:30 | 08:30 | 19:30 | 08:30 | 19:30 | 08:30 | 23:00 |
| AA | £1.00 | £0.01667 | 10:00 | 11:00 | 10:00 | 11:00 | 10:00 | 11:00 | 10:00 | 11:00 | 10:00 | 11:00 |
| AA | £1.00 | £0.01667 | 15:00 | 16:00 | 15:00 | 16:00 | 15:00 | 16:00 | 15:00 | 16:00 | 15:00 | 16:00 |
| AS | £1.00 | £0.01667 | 09:00 | 11:00 | 09:00 | 11:00 | 09:00 | 11:00 | 09:00 | 11:00 | 09:00 | 11:00 |
| AS | £1.00 | £0.01667 | 14:00 | 16:00 | 14:00 | 16:00 | 14:00 | 16:00 | 14:00 | 16:00 | 14:00 | 16:00 |
| B | £1.00 | £0.01667 | 09:00 | 18:00 | 09:00 | 18:00 | 09:00 | 18:00 | 09:00 | 18:00 | 09:00 | 18:00 |
| BB | £1.00 | £0.01667 | 10:00 | 11:00 | 10:00 | 11:00 | 10:00 | 11:00 | 10:00 | 11:00 | 10:00 | 11:00 |
| BB | £1.00 | £0.01667 | 15:00 | 16:00 | 15:00 | 16:00 | 15:00 | 16:00 | 15:00 | 16:00 | 15:00 | 16:00 |
