1 Reply Latest reply: Sep 27, 2018 6:27 AM by Sasidhar Parupudi RSS

    sum - count of two variables

    Christina Kasman

      hi all,

       

      I am trying to create a sum for a unique id based on the count on two variables(Applied Year and Applied Ireland Year) meeting a certain condition (year 2018) - count of AppliedCalendar year = 2018 + count of Applied Ireland Calendar year = 2018. I tried the below formula - but it is not working.

      Note: the year has to be 2018 for only one or the other.

      any suggestions?

       

      sum(aggr(Count({<[Applied.autoCalendar.Year]={"2018"}>} + {<[Applied (Ireland).autoCalendar.Year]={"2018"}>}) distinct [unique id]))