Condition for the status

[vardhancse]

Hi,

Have a requirement is that,

I am trying to create one calculated dimension based on 3 fields.

Fields:

1

2

3

now the condition is that if the count(1=2=3),'Match','Not Match')

if(1= 2 & 2=3,'Matched','Not Matched') as Count_Status

[tresB]

if(1= 2 AND 2=3,'Matched','Not Matched') as Count_Status

Assuming 1,2,3 are field names.

[er_mohit]

try this on front end side

aggr(if(1= 2 AND 2=3,'Matched','Not Matched'),1,2,3)

check on suppress null value