Items Supported in SCalc Calculations

You can use these types of items in SCalc calculations:

References to dimension members. This example references the Account dimension members Purchases and OtherCosts: R6=SCalc(((A#Purchases)-(A#OtherCosts))*100)
Cell references, using the syntax Cell(rowIndex,columnIndex). This example refers to the cell in the fourth row of the second column in the form: R1=SCalc(Cell(4,2))
Row references, using the syntax Row(rowIndex). This example divides row 4 by row 2: R3=SCalc(Row(4)/Row(2))
Note:
For rows or columns that contain member lists, the calculation occurs on the total for the members of the list.
Column references, using the syntax Col(columnIndex). This example adds column 1 and column 3: C4=SCalc(Col(1)+Col(3))
Nested formulas, using parentheses to nest.
Forward references to cells with SCalc calculations
Note:
SCalc calculations are not performed until the data is saved and the calculated results are not displayed on the form until the form is refreshed.

An SCalc row or column can reference another SCalc row or column in its calculation, however you cannot forward reference in a SCalc row or column for another Scalc row or column. For example, this SCalc forward reference is allowed:

C1=A#Sales
C2=A#COGS
C3=SCalc(Col(1)-Col(2))
C4=SCalc(Col(3)/Col(1)*100)