Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

CF_STATIC

The CF_STATIC function can be used to evaluate formulas or nested functions and replace them with the static value so that the formulas don't need to be re-evaluated every time they are used in the template. This function applies to both FORM and REPORT template types.

Important: The CF_STATIC function should be the outermost function to be evaluated. It cannot be used in the middle of the function, as it must be a root function.

Below is an example of how to use CF_STATIC with custom functions:

=CF_STATIC(CF_GETPANEVALUE(VERSION))

In this case, if the CF_GETPANEVALUE (VERSION) function returns a value (e.g. 2021), that value will be the result of the CF_STATIC function.

Below is an example of how to use CF_STATIC with formulas:

=CF_STATIC(LEFT(G6;4))

In this case, if the value in cell G6 is "MONTH", the result of the CF_STATIC function will be "MONT" (the first four characters).

When a cell contains a formula or function the CF_STATIC function is accessible in the right-click cell context menu, as shown below:

Once the CF_STATIC function is added to the cell, you can remove the function by right-clicking in the cell again and selecting Remove CF_STATIC, as demonstrated below:

When removing CF_STATIC, the following applies:

  • If the argument of CF_STATIC is a function (e.g. =CF_STATIC(CF_GETPANEVALUE(UNIT)), then the inner function will remain in the cell (e.g. CF_GETPANEVALUE(UNIT)) and only CF_STATIC will be removed.

  • If the argument of CF_STATIC is a formula, then the formula will remain in the cell and only CF_STATIC will be removed.

Published:

CF_STATIC

The CF_STATIC function can be used to evaluate formulas or nested functions and replace them with the static value so that the formulas don't need to be re-evaluated every time they are used in the template. This function applies to both FORM and REPORT template types.

Important: The CF_STATIC function should be the outermost function to be evaluated. It cannot be used in the middle of the function, as it must be a root function.

Below is an example of how to use CF_STATIC with custom functions:

=CF_STATIC(CF_GETPANEVALUE(VERSION))

In this case, if the CF_GETPANEVALUE (VERSION) function returns a value (e.g. 2021), that value will be the result of the CF_STATIC function.

Below is an example of how to use CF_STATIC with formulas:

=CF_STATIC(LEFT(G6;4))

In this case, if the value in cell G6 is "MONTH", the result of the CF_STATIC function will be "MONT" (the first four characters).

When a cell contains a formula or function the CF_STATIC function is accessible in the right-click cell context menu, as shown below:

Once the CF_STATIC function is added to the cell, you can remove the function by right-clicking in the cell again and selecting Remove CF_STATIC, as demonstrated below:

When removing CF_STATIC, the following applies:

  • If the argument of CF_STATIC is a function (e.g. =CF_STATIC(CF_GETPANEVALUE(UNIT)), then the inner function will remain in the cell (e.g. CF_GETPANEVALUE(UNIT)) and only CF_STATIC will be removed.

  • If the argument of CF_STATIC is a formula, then the formula will remain in the cell and only CF_STATIC will be removed.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk