Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

Difference in Values

Hello,    How can I get a differene from the last value? In this example I need the difference in mileage from the last entry.   (24,695 - 18,923)  (30,781 - 24,695) etc   Example) Shou...
amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

tamerj1 thank you!!! its still a bit off though. 

 

 

Where the first one should be 0 because that is the frist entry, the second one should be 5,772 (24,695- 18,923).

 

third should be 6,086 (30,781-24,695) etc

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

amandabus21 

Fix the date data type. It should be DateTime data type not text data type. 

  • amandabus21's avatar
    amandabus21
    Icon for Helper V rankHelper V
    3 years ago

    tamerj1 still getting the same result