75 Replies Latest reply: Nov 20, 2017 6:49 AM by siddharth soam 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.