Skip to content

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

ArgumentDescription
valuesA single value or a one-dimensional range of values to be written to the relevant datapoint(s).
valueLocationsA single xpna.MEMBER or one-dimensional range of xpna.MEMBER of the same size as [values] to write to.
member1A reference to a single xpna.MEMBER cell.
member2A 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.

See Also

DATA

DATAWRITE

Glossary