@not(condition or formula)


Not something

Used in @if statements to execute a command if a condition is not true.

Example 1

@if(@not(v1750>100000), 1, 2)

If v1750 (Net Income) is less than or equal 1 million, a 1 is returned, otherwise a 2 is returned.

Example 2

@if(@not(@isyear), 1, 2)

Strategic Finance returns 1 if the period is not a year (e.g. a month, quarter...), and a 2 upon other time structures.