Blank Data appears

[Sayad]

When I do two functions simultaneously, the data blank appears. Inside the Virtual Column.

SELECT(CAMPUS SCAN SHEET[PAIR TYPES],[PAIR TYPES]= used pair)+SELECT(CAMPUS SCAN SHEET[PAIR TYPES],[PAIR TYPES]= used single pair)


Note: This expression could impact performance.

(The list of values of column 'PAIR TYPES'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'PAIR TYPES') is equal to ("used pair")) + The list of values of column 'PAIR TYPES'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'PAIR TYPES') is equal to ("used single pair"))

[Rafael_ANEIC-PY]

Hello @Sayad , can you try this expression?

SELECT(CAMPUS SCAN SHEET[PAIR TYPES],OR([PAIR TYPES]="used pair",[PAIR TYPES]="used single pair"))

[Sayad]

I want it to be visible only in detail view. How do I hide from form view? 

[Sayad]

This expression is working but one issue why showing this.

[Rafael_ANEIC-PY]

I take it the expression worked? you can use this expression on that virtual column show_if()

CONTEXT("View")="Your form view name"

[Rafael_ANEIC-PY]

That's just how lists show in table views, you might wish to further expand on your show_if() expression or simply remove it from that table view.

[Sayad]

Virtual column name is not showing in View column. Then how to remove .

[Rafael_ANEIC-PY]

Are you sure you're looking at the correct view configuration? from the screenshot I'm not sure if it is a table or an inline view.