How to check if the variable is empty

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 I want to insert 0s if the variable {PROJECT} is empty and 1s if some any project is selected.

This formula is not working:

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

It sets just empty values in the cells.

Can someone suggest where is the problem?

1 answer

0 votes

Hi @Giga Shubitidze

Welcome to the community.

I expect this is an automation you are running.

Can you provide the automation details for us community member to help you out.

This will provide us with context and details.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Sorry it was question regarding Atlassian Analytics. Is it wrong place to post?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

No, but I can't help you out with this.

I would suggest to raise an issue with Atlassian Support related to your question.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Suggest an answer

Was this helpful?

Thanks!

Atlassian Analytics

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

PREMIUM

PERMISSIONS LEVEL

Product Admin

Product Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Get product advice from experts

Join a community group

Advance your career with learning paths

Earn badges and rewards

Connect and share ideas at events

How to check if the variable is empty

1 answer

Suggest an answer

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

PERMISSIONS LEVEL

TAGS

Atlassian Community Events