This content has been marked as final. Show 5 replies
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 ?