=if(Match(Year_V, '2018') ,[Opportunity Name]) How to add one more condition ?

[paulyeo11]

Hi All

I have below expression at dimension it work fine :-

=if(Match(Year_V,

'2018')

,[Opportunity Name])

I need to add one more condition , that is field name Probability > 0 :-

=if(Match

(Year_V,'2018'),

(Probability,'>0')

,[Opportunity Name])

=if(Match

(Year_V,'2018' Probability,'>0'),

[Opportunity Name])

But it fall to work , can some one advise me where i go wrong ?

Paul

[alexandros17 · Accepted solution]

Try with

=if(Match(Year_V,'2018')>0 and Probability > 0,[Opportunity Name])

But I am not sure you need really this ... try to explain better.

Thanks

[paulyeo11]

Hi Alessan

Thank you very much.

it work fine.

Paul