Rounding
Optionally, you can use rounding in writeback commands. To use rounding, add this sub command in the writeback syntax:
"[[N <X>]]"
Here N is a positive whole number or zero, which specifies the number of decimal places. X is an optional parameter which turns off error correction. Error correction is enabled by default.
Note: You can place the sub command anywhere in the syntax. But we
recommend that you include it after the value command. For example:
Note:
=Cell.write("#W25 [[2]]","Best Practices
OLAP","Analysis","[Period].[All
Years].[2006]","[Valtype].[Variance].[Budget]")
.