Can we have local variables being used in the formulas? For example we have the following formula: var Number tmpSuffix = [CategoryID]; var Number tmpPrefix = If([SortOrderEntered]>0,[SortOrderEntered],[SortOrderCalced]); ToNumber(ToText($tmpPrefix)& "." & ToText($tmpSuffix))