Ben SmithBen Smith
Ben Smith/
🚗
Distance Difference
🚗

Distance Difference

For
Max van Collenburg
From
Facebook
Status
Broken
Formulas
empty
empty
if
if
|| · or
|| · or
Share
Expenses Overview

Distance

if(empty(prop("Mileage")) or empty(prop("Previous Entry")), toNumber(""), prop("Mileage") - toNumber(prop("Previous Mileage")))
if(empty(prop("Mileage")) or empty(prop("Previous Entry")),
Check to see if either Mileage or Previous Entry are empty.
toNumber(""),
If either are empty, display nothing.
prop("Mileage") - toNumber(prop("Previous Mileage")))
If both are not empty, subtract Previous Mileage from Mileage.
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!