xpna.DATASEND FUNCTION
Usage
The DATASEND function is used to write back one or more transaction values against a set of data points. It differs from the DATAWRITE function in that the values to be written are referenced from other cells rather than entered directly into the cell.
This is a context-aware function, so when selected, the xpna task pane will show the details of the Data Send and the ability to perform the writeback for the selected DATASEND cell or all known DATASEND cells.
Syntax
Argument | Description |
---|---|
values | A single value or a one-dimensional range of values to be written to the relevant datapoint(s). |
valueLocations | A single xpna.MEMBER or one-dimensional range of xpna.MEMBER of the same size as [values] to write to. |
member1 | A reference to a single xpna.MEMBER cell. |
member2 | A reference to a single xpna.MEMBER cell. |
[member3..member15] | A reference to a single xpna.MEMBER cell. (optional) |
Note:
Any value from the
values
argument that is not a valid number will be excluded from the writeback
Writeback performance
Writing new values using the DATASEND function will cause all related DATA functions in the workbook to be recalculated. For best performance, it is recommended to keep planning template workbooks as simple as possible and to minimise the number of DATA functions in the workbook, especially if you are using the DATASEND function frequently.
Common Problems
- The function will return an error if the number of values does not match the number of periods.
- The function will return an error if the values or periods arguments are not one-dimensional arrays.
- The function will return an error if you do not provide at least two member ID or cell reference.
- The function will return an error if the hierarchies Scenario, Account and Period are not used.
- All members must resolve to a valid member for your workspace.