is there a simple method to calculate the distance between two values e.g. 10 and 30 which will result to 20. Currently I do it as follows:
CASE WHEN value_1 < value_2 THEN value_2 - value_1 ELSE value_1 - value_2 END AS difference_predicted_days
Advertisement
Answer
The Absolute value function does the trick.
ABS(value1 - value2)