Description

Returns an Access Right typed value corresponding to the read and write Boolean options.

Users must have the Define Application security permission to be able to use this function.

Syntax

ACCESSRIGHTS(Read, Write)

Read (Boolean). Corresponds to the Read option. TRUE allows Members to read data, FALSE prevents reading, BLANK prevents reading.
Write (Boolean). Corresponds to the Write option. TRUE allows Members to write data, FALSE prevents write, BLANK prevents write.

Return type

Access Rights

Examples

Case	Results	Return Type
`ACCESSRIGHTS(true, true)`	`read/write`	`Access Rights`
`ACCESSRIGHTS(true, false)`	`read/no write`	`Access Rights`
`ACCESSRIGHTS(blank, false )`	`no write`	`Access Rights`
`ACCESSRIGHTS(true, blank)`	`read`	`Access Rights`

We recommend to use the BLANK in your formula instead of FALSE where possible in order to benefit from Pigment’s sparse engine. Computations on Pigment are faster on datasets that are sparse; meaning Access Rights metrics that use BLANK in their formulas instead of a value (TRUE/ FALSE) will benefit from this.
See How Pigment Handles Blank Cells for more details.

Excel equivalent: none

See also: RESETACCESSRIGHTS

More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every Function and Modifier in Pigment!

Security functions

Product

Use Cases

Resources

Company

Follow