8 Replies Latest reply: Mar 4, 2016 10:12 AM by PAUL YEO RSS

    How to compute CY vs LY accumulated % var to make it display +4% ?

    PAUL YEO

      Hi All

       

       

      Below expression plot the CY line chart :-

       

       

      Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))

       

       

      Below expression plot the PY line chart :-

       

       

      Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-1)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))

       

       

      I try to create % Var line using below expression :-

       

       

      (

      (

      (

      Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))

      )

      /

      (

      Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-1)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))

      )

      )

      -1)*1

       

       

      The end % i get equal -376% which is wrong , may i know how to get +4 % ?

       

       

      Paul