8 Replies Latest reply: Nov 27, 2017 4:12 AM by Naoual EL RHAFFOULI RSS

    Expression with condition on a list

    Naoual EL RHAFFOULI

      Hello,

      I would like to calculate the sum of number of calls for a list of account.

      Let's say I have added a condition in the load manager to extract only a list of account.

      I set it us as a flag "Y" if the account is in the list, "N" if it's not.

      So I wanted to calculate the sum of number of calls for this list of account that got the condition "Y"

      I used this

      sum({$<[Central Account #]=P({1<Flag={‘Y’}>})>} [Nb of Cases])

      But it gave me 0.

      Do you have any idea what I did wrong?

      Thank you so much for your help,