Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
i am trying to displaying field value percentage using district and Total functions.
on chart for each value im getting the 100%. each value has less than 100% total would be 100%.
can some one help me to resolve this issue.
please find the expression im trying to displaying the percentage
=num(Count(DISTINCT{<RAG_RATING_CD=>}Metric)/COUNT(TOTAL <RAG_RATING_CD> DISTINCT Metric),'#,##0%')
Best Regards,
Niranjan
What is your dimension here?
May be try this if RAG_RATING_CD is your dimension:
=Num(Count(DISTINCT RAG_RATING_CD)/COUNT(TOTAL <RAG_RATING_CD> DISTINCT RAG_RATING_CD), '#,##0%')
try this
num(Count(DISTINCT Metric)/COUNT(TOTAL <RAG_RATING_CD> DISTINCT Metric),'#,##0%')
MonthYear is my dimension
if use below expression for distinct count i am getting only one value
=Count(DISTINCT RAG_RATING_CD)
hi, no changes on percentage im getting same
The object in the image is a list box? If not, what object are you using?
yes its list box only
You mentioned the dimension MonthYear? What was that dimension for? Do you want to calculate the % of each RAG_RATING_CD in the list box or another object?