I'm not certain I understand what you expect but see the attached
the total LOD is
a the percent is
it returns this note - the totals include the 0 values - did know if wanted them removed
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you, Jim...
The issue with percentage is fixed. However, there are issues with Population Strength. Yes, i need to include the count of individuals with no loan in overall population strength. the problem comes with below.
I have two kind of filters,
SET 1 - one will decide the population (like AYR and Area_ID in the example i shared earlier)
and other SET 2 - will decide how many students got the loan, what was the % etc...
Population strength should not get affected by SET 2 filters.
In my real case,
SET 1 is AYR, Class Group, Post ID, Owning Unit, Program Name
when i use
When i use:
I am getting something like below
The correct value for total by post setting in this combination i have set is 84.
I hope this helps in understanding the problem better. Please let me know if you are able to suggest why it is happening so. I was expecting all the row values for Total in this second case to be 84...