Forum Discussion
% in a measure not adding up
Hi All, I have two tables Table A Listed below is how it looks like Reason Date Employee ID Year Flag A 1/1/2021 12341 2021 1 B 1/1/2019 12421 2019 1 Table B It...
If you were 25% over every single month in a year, do you expect the total to be the average amount you were over for the year (25%), or do you actually want to show 12 * 25% = 300%? How do you interpret that 300%?
Hi Alexis,
Thank you for your response! For the year it would be the average.
So far I have the percentages for each month (using my calculation); however they don't add up. I want to add those % for each month, so that I can use the total and divide it by the # of months I have.
