@@ELSE

The @@ELSE command in an Essbase calculation macro designates a conditional action to be performed in an @@IFSTRCMP statement. All actions placed after the @@ELSE in an @@IFSTRCMP statement are performed only if the strings compared in the @@IFSTRCMP statement do not match.

Syntax

@@ELSE...statement [ ...statement ] @@ENDIF

Where statement is operations to be performed depending on the results of the test.

Notes

The @@ELSE statement can only be used in conjunction with an @@IFSTRCMP statement.
All @@IFSTRCMP statements must be ended with @@ENDIF statements.

Example

@@IFSTRCMP (@@2, @_NULL) 
  @@1 
@@ELSE  
  (@@1 + @@2)
@@ENDIF

This test checks to see if the second macro argument is blank. If it is, then only the first argument is used. If the second argument is not blank, then the two arguments are added.