1 Reply Latest reply: Mar 30, 2012 6:09 AM by jagan mohan rao appala RSS

    Normalizing Charts

      Hi,

       

      I have the ffg chart:

      Capture.PNG

       

      I am trying to normalize this graph between 0 and 1.

       

      I just need to get the maximum and minimum for each line and then I can normalize it but I can't seem to get this because my expression,

      is:

                                Value/Value1  which is actually equal to max(Value)/max(Value1), but I do not want this,

      I want Value/Value1 and also get the MAX(Value) throughout the years. so I can eventually use an expression like the ffg:

       

                                                                                 (Value/MAX(Value))/(Value1/MAX(Value1)) --> results in 1 all the  time which I do not  want

       

      PLEASE HELP, this is really important for me to implement.

       

      Kind Regards

      Razak