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?
This is the Formula
I am not sure how you are getting 129.65 after Reducing some value from some. I get 70.43%