1 Reply Latest reply on Jul 20, 2015 7:31 AM by Michel Caissie

    YTD ratio difference

    daniel lim

      Hi

       

      Please find the attached work book for following question.

       

      There is 2 main index which are revenue and logistics cost.

      With those two, I developed 'logistics ratio' and 'YTD logistics ratio' with 'edit shelf' function.

      (As long as I know, 'YTD total' table calculation is not applied for ratio wise index.)

       

      I would like to compare YTD logis ratio against previous year, similar as logistics cost 'YTD growth'.

      In the work book, the value for May 2015 should be 1.54% (=11.54%-10.00%)

       

      Of course, normal table calculation of YTD growth for 'logis %' doesn't give me correct answer, which just gives me 'SUM of calculated ratio gap'.

       

      But I couldn't find a way to solve problem. How can I make it?

       

      Please help.

       

      Thanks and regards,

      Dan