Show_If not working with a Virtual Column

[Steve_Fuller]

I have a virtual column that concatenates with a column

If that column is empty I do not want to show the virtual column

I use a Show_If statement within the virtual column

However, it shows every time whether the column has data or not

**

I use the same code in both the actual column and the virtual column and it works for the actual column

ISNOTBLANK([Banned from])

Any assistance would be appreciated

[Steve]

Please post a screenshot of the configuration screen for the column that produces this line:

[Steve_Fuller]

Hope this is what you want

[Steve_Fuller]

[alphacp]

Steve, the problem is that you concentrate will never be blank as it will always contain “Banned from”. You need to either test for the column to be equal to “Banned from” or even better change the virtual column to be IF(ISBLANK([Banned From]),"",CONCATENATE("Banned from ",[Banned from])). This will leave the vc blank if [Banned from] is blank and hence will not show.

[Steve_Fuller]

Hi Thank you for taking the time to reply. I put your code in the Formula and it works brilliantly.
However, I still do not really understand why the Show_If didn’t work.
Surely putting ISNOTBLANK([Banned From]) in the Virtual Column should only show IF [Banned From] contains data!

But thanks anyway!

[Steve]

Show_If does not affect the display of header columns in a detail view. I consider this a bug.

Attn @Arthur_Rallu