7 Replies Latest reply: Mar 2, 2016 12:05 AM by PAUL YEO RSS

    How to modify long set expression and need 2 Expression for plot 2 line chart into 1 shot expression ?

    PAUL YEO

      Hi All

       

      Chart 1 i thing is good. because only 1 expression & expression is very shot , it can plot 2 line.

       

       

      Sum(

      {<Year={'>$(=year(today())-2)'}>}

      $(ColumnDim51)/$(Columndim89)/1000)

       

       

      $(ColumnDim51) allow me to slect display sales , gross profit.

       

       

      Chart 2 is not so powerful , it require very long expression and 2 expression compare to chart 1.

       

       

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

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

       

       

      {$(ColumnDim51) allow me to select display revenue or net profit.

       

       

      Now my question is , how to modify the chart 2 expression and make it only 1 expression by follow chart 1 example ?

       

      Muy next posting will enclosed my QV Doc

       

      Paul