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
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.