6 Replies Latest reply: Jul 3, 2016 12:12 PM by PAUL YEO RSS

    Expression Column(1) / Column(2) work but use full expression not work in QS

    PAUL YEO

      Hi All

       

      My Column 1 Expression work fine :-


      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={[CASH SALES],'Singapore','EXPORT'}>}sales/Rate)

       

       

      My Column 2 Expression work fine :-

       

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"}>}sales/Rate)

       

      I need to compute Ratio of Column(1) and Column(2) as below expression :-


      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={[CASH SALES],'Singapore','EXPORT'}>}sales/Rate)
      /
      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"}}>}sales/Rate)

       

      But it return null , can some one advise me.

       

      I cannot make use of Column(1) / Column(2) , because i will be apply the expression in KPI.

       

      Paul