4 Replies Latest reply on Jun 20, 2018 2:42 PM by Aradhana Lakshman

    Difference between two Values

    Aradhana Lakshman

      I Have two fields: Projected Commission and Actual Commission. I am creating another calculate field(Named as forecasted commission here) for the difference between these two. As you see i the picture below the

      simple calculation is returning the wrong value. The actual difference between 6,407,939.11 and 2,510,828.53 is 3,897,111. But the formula: Projected Commission - Actual Commission returns -189,597