8 Replies Latest reply on Mar 17, 2016 7:17 PM by Shivang Desai

    Cannot mix aggregate and non-aggergate comparsions or results in IF Expression

    Shivang Desai

      Hi All,

       

      I am stuck in this question and so majority of my work is stalled.

       

      I have written the logic below but getting error in calculation. Is there any way to solve this?

      SC1.png

      [Metric to View] is a parameter which is working for other things except "Expired Members"

       

      [NOTE: There are 2 important things to note:

       

      1) THERE IS A SEPERATE METRIC CALLED "Expired Members"

      2) THERE IS A CALCULATED FIELD CALLED "Expired members"

       

      ]

       

      My Expired members is a calculated field as shown below:

       

      SC3.png

       

       

      Thanks,

      Shivang Desai