22 Replies Latest reply: Jun 6, 2017 7:24 AM by P M RSS

    how to write max yoy value expression in a textbox

    naveen kumar

      How All,

                        I have to display max YOY increase value

       

      Untitled.png

      to get max YOY increase value which is (67%) in 2016 i wrote below expression in text box ,but i am getting -0 value

      Expression:  =num(Max(Aggr((Sum(value)-Above(Sum(value)))/Above(Sum(value)), year)),'###0')

      some thing is wrong with this expression

      can any suggestion plz



      thanks