Bookshelf Home | Contents | Index | Search | PDF |
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.
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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Interactive Designer Administration Guide Published: 18 April 2003 |