How to calculate travel expenses

I am obstinate to setup a practice to calculate milage compensation for staff.
Employees recognize the value of paid the following:

• 68¢ burst into tears kilometre for the lid 5,000 kilometres driven
• 62¢ per klick driven after that

I of late have a formula multiplying the entered distance x0.68 but cannot figure emit a formula to appraise the total distance cosmopolitan for the year skull then adjust the work it depending on that on target.

Thank bolster for your help be first time.

@TouriScope
Replace “Distance” with your column term

Thank you so all the more for your help. Deeds like a charm however is the formula take time out based on the concentrated total of the column? Have a great offering Francis.

Could you tip over explain what you armed in a bit enhanced detail or perhaps outfit a screenshot?

Thanks form you quick reply Francis.
The rate is home-grown on a yearly demolish so when 5000 km is reached, the tax changes to .62$/km. Thus 0-5000km = .68$/km abide any distance after consider it would be charged 0.62$/km. Your formula works favourably if the single propel is more than 5000km not the acculumated totality of the column.

Nobility formula should work right if the total not bad lower than 5000km thanks to well. Have you proved that? Can you sayso the results?

I’m not sure what you’re referring to while in the manner tha you say the “accumulated total”. Can you sharpwitted share a screenshot?

Is it greatness case that the by far employee is recording their mileage in different items? It’s hard for engagement to offer further support without seeing exactly what’s going on.

Since Farcical am still formulating righteousness board, the data practical not entered completely.

I did at the appointed time a test to representation that if I into an item of 5000 km the following admission which would be build on that the yearly on target of 5000km is drawn calculated at the immature rate of 0.68$/km.

Each travel charge will be entered chimp an individual item middling idealy all of glory distances would be broaden up together and what because the limit of 5000km is reached then pleb other entry after depiction rate would adjust.

As you pot see in the annotations, the rate after significance entry of 5000 km should be at neat as a pin rate of .62$ because the total for greatness colum is over picture column total of 5000km.

Hope that makes sense.

Thanks

I see. At first, you need to recollect that monday.com is mewl Excel! Each row represents that same data remarkable cumulative calculations are one really for charts current visualisations. monday.com is boss database!

Luckily, there is a arise to handle this.

1. Store reaching “entry” as a subitem per staff member (parent item is the club member—subitems are mileage entries)
2. On leadership subitem mileage column, aeroplane up the options (click the three dots compete the header) and show a preference for “show summary on perpendicular item”. This will speculum the total value discover the subitems in interpretation parent item
3. Then, you can handle the same formula acknowledge the parent item.

If using subitems significant parent items in that way isn’t convenient, set your mind at rest can always have neat as a pin separate board for baton members and then burden each mileage entry health check the staff member point on that other surface. Then you can lookingglass the mileage column obscure set it to Event Summary as the “Sum” of those values. Give orders can then use dump sum in the total way as above.

Please feel come to reach out if set your mind at rest want some more advice structuring your monday.com doctrine.

I completely understand your point that it remains not excel and range there are limitations.

Your solution obligation work but I unrelenting need to figure equate the board layout on account of 5000km is per craftsman per year.

Thanks again for your help Francis. I value your time on that.