1 Reply Latest reply on Mar 15, 2018 3:17 PM by Deepak Rai

    ABS Formula

    Tim McDowell

      I'm trying to use ABS similar to how I would use it in excel but it's not working for me.  I'm trying to get a % of increase using negative numbers.  Example:  Plan number (36,517), actual number 10,798 in excel the formula is (actual-plan)/ABS(Plan), which in this example would calculate 129.6%.  How do I write this formula in Tableau?