Siebel Interactive Designer Administration Guide > Working with Configuration Tables > Cell Functions >

Nested Cell Functions


You can nest cell functions, but be aware of how the nested expression is evaluated. Cell functions are evaluated from left to right and bottom to top, as in Figure 17.

Figure 17. Order of Evaluation for Nested Cell Functions

Click for full size image

The numbers in this chart represents the order in which functions are evaluated. A larger numbered table can reference values in a smaller numbered table.

For example, table 1 has a column RESTRAINT_PRICE with cell function (LEASH.PRICE+HARNESS.PRICE).

In this case, table 8 (MAIN) could have a column TOTAL_PRICE with (RESTRAINT_PRICE+PET.PRICE).

You cannot reverse the cell functions and have the second cell function in table 1, and the first in table 8 due to the order of evaluation.

Because tables are evaluated from left to right, you also need to be careful about which cells you reference. When referring from a Configuration table to a Feature table, you can only refer to cell functions that are in your table to the left, or to a literal anywhere in the Feature table. In Configuration tables, you can reference literals anywhere in any Configuration or Feature table.


 Siebel Interactive Designer Administration Guide 
 Published: 18 April 2003