Percentages in a table

Q&A
,
1

I have a table which i am grouping credit scores into the following:
image

RunID is what the case id is stored in, and for this table has been set to distinct_count

What i want to do is create a calculated field which works out the percentage of cases in each credit quality. I understand that for each credit quality, do the distinct_count of cases in that group divided by total cases, but not sure on how to calculate and insert into this table.

2

Hi @HarveyB-B ,

You can calculate the numerator as a LAC at credit quality level, something like
distinctCountOver(RunID,[credit_quality],PRE_AGG)

And for the denominator you would need to calculate total which remains constant for each credit quality row. This should be something like
distinctCountOver(RunID,,PRE_AGG)

Hope this helps.

Thanks,
Prantika

1 Like
3

Hi @HarveyB-B,
It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @HarveyB-B,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information if needed.

Thank you!