I have a chart that shows statuses of loan applications. For each status, I would like to show the percentage of that status vs. the total # of apps.
I've tried with nested ifs:
if(if(CUDCDATA.DECISIONTYPE='Approved',count(CUDCDATA.DECISIONTYPE)/count([CUDC APPID])),
if((CUDCDATA.DECISIONTYPE='Approved w/Condtions'),count(CUDCDATA.DECISIONTYPE)/count([CUDC APPID])))
and also:
count(DISTINCT(CUDCDATA.DECISIONTYPE))/Count(CUDCDATA.DECISIONTYPE)