Other Functions

Introduction

Logical functions check if the entered data fits a particular condition. They return "True" and "False" as 1 and 0 respectively.

Popular logical functions include:

  • Find out if fields are empty of data (IsNull)
  • Find out if fields are even or odd (Even, Odd)

Document functions return data about the document.

Popular document functions include:

  • Show the report Name and Author (DocumentAuthor, DocumentName)
  • Show user choices (DrillFilters, Prompts)

Other Popular Functions

Note: Some of these functions will never have contents between their following parentheses, but they still need to have them.

If-Then

If-Then conditional statements are covered in the If-Then Guide.

IsNull

Syntax: IsNull([Object_name])

Explanation: This function returns true ("1") or false ("0") based on whether or not the object selected is empty of all data. This can be particularly helpful in If-Then statements.

Example: =IsNull([MY CLASS])

Screenshot of InfoView showing isnull function

Even

Syntax: Even([Object_name])

Explanation: This function will return true ("1") or false ("0") based on whether the object selected is an even number.

Example: =Even(Numbers Variable)

Screenshot of InfoView Even and Odd functions

Odd

Syntax: Odd([Object_name])

Explanation: This function will return true ("1") or false ("0") based on whether the object selected is an odd number.

Example: =Odd(Numbers Variable)

Screenshot of InfoView Even and Odd functions

DocumentAuthor

Syntax: DocumentAuthor()

Explanation: This will show the username of the document author.

DocumentName

Syntax: DocumentName()

Explanation: This function will show the name of the document.

DrillFilters

Syntax: DrillFilters()

Explanation: This function will show all of the drill filter values if any are selected.

PromptSummary

Syntax: PromptSummary()

Explanation: This function will show the prompt values if any have been filled out.