Why wouldn't Select() expression show the sam...

[WhiteCrow_MD]

Why wouldn’t Select() expression show the same result as Ref_Rows()?

I am trying to make a virtual column with a list with conditinal expression, I tested the ref_rows() and I found that it serves the function of Select(). Since I want a conditional listing, I made an expression out of Select().

Select (Admission[Name],

AND([Surgeon]=[Name],

[Histopathology]=Yes,

Isblank([Histopath Number]),

Isblank([Histopathologic Report])

) )

Verify says it is Ok, but doesn’t seem to give the correct ouput. Thank you