How to check if variable is empty

Giga Shubitidze_yuhj26

 

I have one control (dropdown) called "PROJECT" where I choose jira project and then one chart where I list all issues of selected project.

Fore some reasons, in custom column of the chart table I want to insert 0s if the variable {PROJECT} is empty (when no project is selected in "projects" dropdown) and 1s if some any project is selected.

I'm using this formula in custom column:

case when {PROJECT} is null then 0 else 1 end

The formula inserts just 1s. But nothing is selected. Help me how to identify if nothing is selected in the control?

 

Tracy Chow_f2gtzj

Hi Giga,

Can you try this instead? 

case when {PROJECT} = '' then 0 else 1 end

This worked for me with a single select dropdown.