Set up a targets in xls form builder where a notification pops us on a multiplication of 5000 KMs

Hi, I am not sure how you plan to sum all the distances travelled across multiple days but the calculation you want for the remaining kilometres until next service is:
5000 - (${total_km} mod 5000)

The results of the calculation could be displayed in a note. In an example of an ambulance having travelled 16,500km it would calculate as 16,500 mod 5000 = 1500 and then then output 3500.

1 Like