A RPAS rule clarification
Hi Exparts,
Need help for the below.
I have 3 measure which have data as below
m1
opt1,loc1,1,MAXI
opt1,loc1,2,PLAIN
opt1,loc1,3,
opt1,loc1,4,Red
opt1,loc1,5,Essential
m2
opt1,loc1,1,MAXI
opt1,loc1,2,PLAIN
opt1,loc1,3,ALL
opt1,loc1,4,Red
opt1,loc1,5,Essential
written rule in below way
m3 = if(m2 == "All", true,if( m1 !=navalue(m1 ) && m2 != navalue(m2) && textCompare(m1,m2) ,true,ignore))
m3 is coming as below
opt1,loc1,3,true
but nothing is happening for 1,2,4,5.
My question here how RPAS rules work .Please correct me for my below understanding
by writing rule for m3 I want to check all cells for opt1,loc1 for 1,2,3,4 and 5 values.