3 Replies Latest reply: Nov 6, 2017 5:38 PM by Sunny Talwar RSS

    Conditional Measure Expression

    Marco B

      Is it possible to switch to another expression based on a variable value ?

       

      Example

       

      Measure Expression P_COUNT:


      = IF (v_IsClosed = "Yes")       

           COUNT( { $< [P.Type]=, DateType= { 'Closed' }> } P_Id )  

      ELSE       

           COUNT( { $< [DateType]={ 'Ref' }> } P_Id )


      ..Is there a workable solution to this ?