Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want below if condition in single if condition.
I am using below code for titles.
if(GetFieldSelections(Product)='SM' and GetFieldSelections(Territory)>0,'Sales(KL)', 'Sales(TKL)'
if(GetFieldSelections(Product)='DM' and GetFieldSelections(Territory)>0,'Sales(MT)', 'Sales(TMT)'
))
Thanks & Regards,
Sachin Yadav
Hi,
Can you explain the logic? I can propose this two solution but I'm not sure.
//You can try
If(GetFieldSelections(Territory)>0,
Pick(Match(GetFieldSelections(Product), 'SM', 'DM'), 'Sales(KL)', 'Sales(MT)'),
Pick(Match(GetFieldSelections(Product), 'SM', 'DM'), 'Sales(TKL)', 'Sales(TMT)')
)
//Or
If(GetFieldSelections(Product)='SM',
If(GetFieldSelections(Territory)>0,
'Sales(KL)',
'Sales(TKL)'
),
If(GetFieldSelections(Product)='DM' and GetFieldSelections(Territory)>0,
'Sales(MT)',
'Sales(TMT)'
)
)
Aurélien
Hi,
Can you explain the logic? I can propose this two solution but I'm not sure.
//You can try
If(GetFieldSelections(Territory)>0,
Pick(Match(GetFieldSelections(Product), 'SM', 'DM'), 'Sales(KL)', 'Sales(MT)'),
Pick(Match(GetFieldSelections(Product), 'SM', 'DM'), 'Sales(TKL)', 'Sales(TMT)')
)
//Or
If(GetFieldSelections(Product)='SM',
If(GetFieldSelections(Territory)>0,
'Sales(KL)',
'Sales(TKL)'
),
If(GetFieldSelections(Product)='DM' and GetFieldSelections(Territory)>0,
'Sales(MT)',
'Sales(TMT)'
)
)
Aurélien
I am using below code which is working fine till line number 3. Line number 4 Is not working.
I want default Sales Volume(TKT) in title so i am using line 1.
when i select any product and territory (Line 2 and line 3) then it should come Sales Volume(KL) or Sales Volume(MT) according to selection of pickmatch.
Line 4 is not working. Sales Volume(TKL), Sales Volume(TMT) output is not getting in title and it should come when i select any product only
=If(GetSelectedCount(Product)=0,'Sales Volume(TKT)', // Line 1
If(GetFieldSelection(Territory)>0, //Line 2
Pick(Match(GetfieldSelections(Product),'PGP','DGP','NPG','CGP','AUTO LPP'),'Sales Volume(KL)','Sales
Volume(KL)','Sales Volume(MT)','Sales Volume(MT)','Sales Volume(MT)', //line 3
Pick(Match(GetfieldSelections(Product),'PGP','DGP','NPG','CGP','AUTO LPP'),'Sales Volume(TKL)','Sales Volume(TKL)','Sales Volume(TMT)','Sales Volume(TMT)','Sales Volume(TMT)' //Line 4
))))
Thanks & Regards,
Sachin Yadav
Yes it is working by using below code. my code was not working because I was not using bracket in pick match.
Thanks Aurelien_Martin
If(GetFieldSelections(Territory)>0,
Pick(Match(GetFieldSelections(Product), 'SM', 'DM'), 'Sales(KL)', 'Sales(MT)'),
Pick(Match(GetFieldSelections(Product), 'SM', 'DM'), 'Sales(TKL)', 'Sales(TMT)')
)