0 Replies Latest reply: Jun 6, 2013 7:43 PM by Breanna Hume RSS

    Using selection(s) in Expression

    Breanna Hume

      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)