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, 15:03

flandsberg's gravatar image

flandsberg
3114
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, 10:03

Marcelo's gravatar image

Marcelo
806611
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:

×198

question asked: 19 Sep, 15:03

question was seen: 62 times

last updated: 21 Sep, 10:03