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

asked 19 Sep '17, 15:03

flandsberg's gravatar image

flandsberg
10122979
accept rate: 0%


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

permanent link

answered 21 Sep '17, 10:03

Marcelo's gravatar image

Marcelo
807918
accept rate: 18%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×494

question asked: 19 Sep '17, 15:03

question was seen: 2,095 times

last updated: 21 Sep '17, 10:03