How to assign a null value to a calculated field?

  • Asked
  • Active
  • Viewed 3053 times
0

Hi,

In certain instances, I want my calculated field to be assigned a null value. I cannot find the right syntax for it. Would anybody know?

Thanks,

Florence

1

Accepted answer

Dear Florence,

Fields are assigned as null (na) when a condition you imposed for that attribute is not met. Therefore, if you need to set a value as null, you just create a condition "Apply when". If it is met, you get a value, if it is not, you get a null.

Let us know if it worked. Marcelo

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.