Skip to Content
0
Former Member
Jun 30, 2016 at 06:38 PM

Match condition in webi 4.1

3937 Views

Hi,

I have a requirement wherein if Terms <=27 for India, then Revenue should display 0. This is applicable only for Country "India".

Country Terms Revenue India 27 100 USA 25 200 India 31 300 UK 40 400

I tried the following formula in Revenue column but it considers all the Terms which is <= 27 and not only for India.

=If (Match([Country];"Ind*") + [Terms]<= 27) Then 0 Else [Revenue]

Thanks