5 Replies Latest reply: Mar 9, 2017 2:43 AM by Rahul Pawar RSS

    How to combine 2 Table into 1 ?

    PAUL YEO

      Hi All

       

       

      I have 2 Expression for Table 1 & 2 as below , May i know how to combine both table into one ?

       

       

      I try to do , but i don't know where to start. Hope some one can advise me.

       

       

      Paul

       

       

      Table 2 Expression :-

       

       

      money(

      SUM({<year = {'$(=Max(year)-1)'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}$(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

       

       

      Table 1 Expression :-

       

       

       

       

      if

      (

      match([Pls select 70 Dim],'rEVENUE'),

      money(

      SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},$(ColumnDim71)={$(ColumnDim71)}>}Amount*1)/$(Columndim89)/1000,

      $(vMoneyFormatK)),

       

       

      if

      (

      match([Pls select 70 Dim],'sales'),

      money(

      sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000),

      $(vMoneyFormatK)),

       

       

      if

      (

      match([Pls select 70 Dim],'eXP'),

      money(

      SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},$(ColumnDim71)={$(ColumnDim71)}>}Amount*-1)/$(Columndim89)/1000,

      $(vMoneyFormatK)),

       

       

      if

      (

      match([Pls select 70 Dim],'n_PRO'),

      money(

      SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},$(ColumnDim71)={$(ColumnDim71)}>}Amount*1)/$(Columndim89)/1000,

      $(vMoneyFormatK)),

       

       

       

       

      ))))

       

       

       

       

       

       

       

       

      /*

      if

      (

      match([Pls select 66 Dim],'rEVENUE'),

      money(

      SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/1000,

      $(vMoneyFormatK)),

      if

      (

      match([Pls select 66 Dim],'sales'),

      money(

      sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

      if

      (

      match([Pls select 66 Dim],'eXP'),

       

       

      SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/1000,

       

       

      if

      (

      match([Pls select 66 Dim],'n_PRO'),

       

       

      SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/1000,

       

       

       

       

      ))))

       

       

      /*

       

       

      if

      (

      match([Pls select 66 Dim],'rEVENUE'),

       

       

      SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/1000,

       

       

      if

      (

      match([Pls select 66 Dim],'sales'),

       

       

      sum({$<year = {$(=max(year)-0)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000),

       

       

      if

      (

      match([Pls select 66 Dim],'eXP'),

       

       

      SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/1000,

       

       

      if

      (

      match([Pls select 66 Dim],'n_PRO'),

       

       

      SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/1000,

       

       

       

       

      ))))