3 Replies Latest reply on Jan 13, 2014 12:11 PM by Peter Gilks

    ABS Function - Absolute is not calculating the absolute value.

    Karthik Ravikumar

      Absolute function is not calculating the absolute value.

       

      I have attached a table, has 2 columns - ScenarioName and Cost. My objective is to calculate the difference between any 2 scenarios selected and then to find the absolute of the difference.

       

      When I select A(Cost = 1) and B (Cost = 2) then I want the difference as -1 and absolute difference as 1.

       

      Can someone help me figure out what I am doing wrong or how to make it behave it like I want to.