Forum Discussion
Solved
Bug in %GT calculation
Hi all! I've created bins to distribute the "Value". I created a matrix where each value is the sum of "Values" that fall into the exact bin. If I select "present "Values" as a percent o...
- Is that the same data in both tables? The numbers don't seem to match.
% GT is not absolute, it should just take the value and divide by grand total value (23,218.49 in your top chart).
If you want a different calculation, please explain what the calculation should be and we can help you create custom measure. I don't really know how you would accurately create a percent when negative numbers are involved, do you need to update the total to be an absolute sum?
AllisonKennedy
Community Champion
Community ChampionIs that the same data in both tables? The numbers don't seem to match.
% GT is not absolute, it should just take the value and divide by grand total value (23,218.49 in your top chart).
If you want a different calculation, please explain what the calculation should be and we can help you create custom measure. I don't really know how you would accurately create a percent when negative numbers are involved, do you need to update the total to be an absolute sum?
% GT is not absolute, it should just take the value and divide by grand total value (23,218.49 in your top chart).
If you want a different calculation, please explain what the calculation should be and we can help you create custom measure. I don't really know how you would accurately create a percent when negative numbers are involved, do you need to update the total to be an absolute sum?