There is non_negative_difference. But in my case, where soilmoisture decreases i want to know how much water left without the water added when watered. Is there a way to turn non_negative_difference around?
Heya. Bit late, maybe you can do something like
select non_negative_difference(value*-1)*-1
