Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Does it mean this?
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 < 6, Dual('<6 Mth', 1),
my QVW
Does it mean this?
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 < 6, Dual('<6 Mth', 1),
Hi Anil
It does not get the correct figure. I need to spend more time to analyse your expression.
Paul
I don't have access your application now? So, I can't look. can you tell me exactly what r u trying
I see . how you develop this skill ? can you share with me pls.