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

    Normalizing Charts

    Abdur Razak Amod



      I have the ffg chart:



      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,


                                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