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?


      [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:






      Shivang Desai