Can you explain what is the expectation here?
Thank you for your response!
I am trying to get something like this:
Profit Ratio (12 Mo. Av) = %10
Profit Ratio (August) = %11
Profit Ratio (% change) = 0.1%
Normally, I have been using percentage points to show the difference. (EX: Profit Ratio ( % change) = 1 point.) However, I am unable to do this in tableau so I was just going to use the % difference instead. Please let me know if this still doesn't make sense.
Diana -- the change in profit ration in your example should be 10%, not .1%
I'm seeing correct values (I think) in your workbook already. Moving from 13.88 to 12.32 is a decrease of 11.3% (November 2018 numbers.)
Thank you, Joe!
You are right - my brain is clearly not working today. Thank you for the correction.
Do you happen to know how I could make it show the point difference? It is much easier to understand visually that way.
Also, I am looking at December 2018 and it is showing incorrect values:
Thank you, Joe!!