Functions

The quarterEnd() function returns the date of the end of the Fiscal Calendar quarter based on a date input. Syntax...

The yearStart() function returns the date of the start of the Fiscal Calendar year based on a date input. Syntax...

The yearEnd() function returns the date of the end of the Fiscal Calendar year based on a date input. Syntax...

The join() function provides the ability to convert a list of values into a formatted, filterable text string. Syntax join(separator,...

The unionIf() function provides the ability to create a list of Text, Association, or Pick List values across descendant or...

The union() function allows for the combination of multiple unionIf’s or the combination of values of the current item into...

The not() function reverses the result of a comparison expression, allowing users to test for the opposite of a given...