SAVEROW
Creates a new calculated row whose default name is rowMbr, but which may be renamed with an optional name enclosed in quotation marks.
The command automatically stores the data associated with rowMbr, and this data can be referenced by any CALC ROW, CALC COLUMN, PRINTROW command, or any other that can reference a calculated row.
When the command is used, the calculation operator for that command is set to OFF, so that its contents are not affected unless the user explicitly turns the operator back on. SAVEROW captures the data, but suppresses its output.
Syntax
{ SAVEROW ["newRowCalcName"] } rowMbr !Parameters
- newRowCalcName
-
Optional. Name, enclosed in quotation marks, for the data row created by the SAVEROW command. The name can be multi-part, separated by a tilde (~), as in the CALCULATE ROW and CALCULATE COLUMN syntax.
- rowMbr
-
Default row member used to determine the row name for the calculated data row.
rowMbr is the next member encountered after the { SAVEROW } command, so other intervening { } format commands or non-member-selecting < commands are allowed and do not affect which member is saved.
Notes
There is no conflict with a member and a calculated row having the same name. They are separate entities even though they have the same name.
Example
The following example is based on Demo Basic.
{TEXT 18 "Expenses as % of Sales for January"}
Jan Boston Audio
Actual Budget
{SAVEROW} Sales !
{CALCULATE COLUMN " Actual%" = 1 % "Sales" 1
CALCULATE COLUMN "Budget%" = 2 % "Sales" 2}
COGS Misc
Payroll
Marketing
Sales
!
Which produces the following report:
Expenses as % of Sales for January
Jan Boston Audio
Actual Budget Actual% Budget%
======== ======== ======== ========
Cost_of_Goods_Sold 941 1,007 47 47
Miscellaneous 4 0 0 0
Payroll 542 530 27 25
Marketing 134 130 7 6
Sales 1,985 2,150 100 100Related Topics