PADVALUES function
PADVALUES ( values, times, with value)
PADVALUES pads the values with with_value or blank if no with_value is provided as many times as specified.
Example
How to use the PADVALUES function
The PADVALUES function returns the selected values with "padding" taken from the with_value element as many times as specified in the times element. For instance, if you wanted to pad the values (1,2,3) three times with the value "4", the PADVALUES function would return the following array: 1,2,3,4,4,4.
To use the PADVALUES function
- Select a component from the Component Tree.
- Click the Start Formula link in the formula editor.
- Click the Insert Function button on the formula editing toolbar.
- Select Data Manipulation > PADVALUES from the Function's menu.

- Click the values node
- Select the values to "pad".
- Click the times node.
- Click the Insert a literal string or number button.
- Type a value.
Note: This value will be the number of instances the with_value is repeated.

- Click the with_value node.
- Click the Insert a literal string or number button.
- Type a value to "pad" the values selected with.

Learn more:
Now that you know more about the PADVALUE function, check out the following tutorial: