How to return null value for a list formatted line item

GAPER

Is there a elegant way to do that? currently i am using one column to return text value and another column to find back the item. Because it won't allow me to enter

if in tier = True then Item(Tenure) else ""

because "" is not in the list of Tenure.

umangsinghal

Replace " " to the BLANK in your formula

HarrisonDuncan

In your formula, substitute " " for the BLANK.

Regards,
Harrison run 3