I have a field that is simply calculating the difference between two other fields. Although the results are negative numbers, positive numbers or 0, the person who requested the report wants to see the absolute value. So I used ABS(c2-e2).
They also wanted icon sets (the arrows), so they can visualize the positive and negative.. Over 0 up arrow, below zero down arrow, 0 horizontal. The issue is that using ABS they are all positive numbers.. any ideas
They also wanted icon sets (the arrows), so they can visualize the positive and negative.. Over 0 up arrow, below zero down arrow, 0 horizontal. The issue is that using ABS they are all positive numbers.. any ideas