5 Replies Latest reply: Dec 21, 2017 1:08 AM by Yeo Poh sai RSS

    How to make both my Table 1 & 2 overall amount same ?

    Yeo Poh sai

      Hi All


      I have modify the Table 2 Dimension expression on new product script by adding addition filter for month_n > 3 consider new productr, it work fine :-


      if(L_issue = '00/00/0000' AND L_move <> '00/00/0000' AND Month_n > '3', ('New Product'),


      Note from Table 1 new product amount from 130,468 reduce to Table 1 39.551 , Total amount reduce = 90,917


      Below is my Table 2 org script for <6 Mth :-


      If([No of Months_] >= 1 and [No of Months_] <= 6, Dual('<6 Mth', 1),


      Now i need to add the below new condition into above <6 Mth script.


      So i assume it should be like below :-


      If([No of Months_] >= 1 and [No of Months_] <= 6 and L_issue = '00/00/0000' AND L_move <> '00/00/0000' AND Month_n < '4', Dual('<6 Mth', 1),


      ( I include new product month_n < 4 to <6 Mth  )


      But it does not work.


      If it work , Table 2 should display :-


      <6 Mth amount = 718,570 (536,736 + 90,917) , now it display 536,736 is worng 


      My objective is make table 1 and 2 overall total amount same.


      Hope some one can advise me where i go wrong ?


      PAul Yeo