Forum Discussion

darko861's avatar
darko861
Resolver II
4 years ago
Solved

IF statement in a Matrix

Hi all, I have the following Matrix visual as shown down below. Is it possible to tweak the "W/O Reason" measure to get a text line called "Various reasons" in the row "SR_Service_RecID" (11882) in ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    W/O Reason = 
var r = countrows(values(xxx[No_bill_reason_3]))
return switch(true(),r=1,max(xxx[No_bill_reason_3]),r>1,"Various reasons",BLANK())
lbendlin's avatar
lbendlin
Super User
4 years ago
W/O Reason = 
var r = countrows(values(xxx[No_bill_reason_3]))
return switch(true(),r=1,max(xxx[No_bill_reason_3]),r>1,"Various reasons",BLANK())
  • darko861's avatar
    darko861
    Resolver II
    4 years ago

    This is exactly what I needed, thanks a lot!