70 Replies Latest reply: Nov 17, 2017 7:30 AM by Sunny Talwar RSS

    Can we put condition in max function

    siddharth soam

      Hi

       

      I want to apply a condition in max function.

       

      Max({<[Fiscal Year]='FY16'>}( mid(Quarters,2)))

       

      Ideally it should give me 4, but its not returning any value.