3 Replies Latest reply: May 15, 2014 1:30 PM by Jean-Pierre Bakhache RSS

    Set Analysis Question

    Matt Maino

      Hi everyone,

       

      I have an expression set up in a chart that works fine until I start drilling down on data, and I'm wondering if any of you can identify why this is happening. I'm assuming that it has to do with incorrect identifiers. Expression is shown below.

       

      Sum({$<current_balance=P({1<loanType={'Type1'}, daysPastDue={">=0<=10"}>}current_balance)>}current_balance)/(Sum({$<current_balance=P({1<loanType={'Type1'}>}current_balance)>}current_balance))

       

      What I am trying to do is calculate a % of current_balance by calculating the sum of current_balance of Type1 loans in the 0-10 daysPastDue range and dividing that by the sum of current_balance for all loans of that type. As I said above this works fine until I drill down on data. Is there any syntax that I need to change for this to work if I narrow down by other fields? Thank you.