CalcByRow

A keyword used to change the default calculation order (columns first) to rows first. This keyword applies to the entire form.

Syntax

CalcByRow=Boolean

Where Boolean is True if row calculations are used; False if column calculations are used.

Example

ReportType=WebForm

ReportLabel=CalcByCol

ReportDescription=Demonstrate CalcByRow

BackgroundPOV=S#Actual.Y#2014.P#January.w#<Scenario View>.E#UnitedStates.Connecticut.V#USD.A#Sales.I#[ICP NONE].C1#Golfballs.C2#Customer2.C3#[None].C4#[None]

C1=S#Actual

C2=S#Budget

C3=SCalc(Col(2)-Col(1)),CustomHeader:Variance

C4=SCalc(Col(3)/Col(1)),CustomHeader:Variance %

R1=A#Sales

R2=A#Purchases

R3=A#OtherCosts

R4=SCalc(Row(1)+Row(2)+Row(3)),CustomHeader:Total

ShowLabels=True

CalcByRow=False