3 Replies Latest reply: Oct 26, 2010 10:33 AM by Roland Kunle RSS

    formula to YTD Analisys

    jalmanza

      hey Qliks...

      i've a table like this, but i need to complete the VAR WTD column:

      the excel formula is : (TRP´s of the selected week)/ (TRP's of before week) - 1

      example: if i selected 6 in Semana's table then:

      (TRP´s of 6th week) / (TRP's 5th week) - 1

      in excel, i obtain this value, but in QV how can i do this?.

      thousand tnxs!!!

      error loading image