This content has been marked as final.
Show 4 replies
-
1. Re: Percent Difference calculation
haitham Farouk Dec 20, 2017 9:35 PM (in response to Akrati Kher)Send sample of data ... and view you expected ..
-
2. Re: Percent Difference calculation
Akrati Kher Jan 8, 2018 1:01 PM (in response to haitham Farouk)Thanks, we did this
-
3. Re: Percent Difference calculation
Peter Fakan Jan 8, 2018 2:10 PM (in response to Akrati Kher)Hi Akrati,
To calculate percentage: Original Number - New Number. Then: divide the decrease by the original number and multiply the answer by 100.
or in pseudocode
(sum[Column A] - sum[Column B]) / sum[Column A] * 100
HTH
Peter
-
4. Re: Percent Difference calculation
Jeff Shyu Jun 19, 2019 11:36 AM (in response to Akrati Kher)I actually found a pretty useful YouTube video about this: How to Show Month Over Month Difference As a Percentage in Tableau - YouTube