LVBATCHCOMMENT Function

Download Add-in for Office Guide

The LVBATCHCOMMENT function allows you to define a custom comment for data submission batches in the Longview Add-In for Office. The LVBATCHCOMMENT function applies only to submissions made from the worksheet on which it is defined. It does not apply to the entire workbook.

You can use the LVBATCHCOMMENT function in the following ways:

• Type the function syntax into a worksheet cell.
• Complete the function parameters in the Function Arguments dialog.

LVBATCHCOMMENT syntax

In the worksheet cell, type:

=LVBATCHCOMMENT("comment text")

where:

Comment is a comment text for the data submission batch (maximum 100 characters)

For example:

=LVBATCHCOMMENT("Updated revenue assumptions for Q2")

Defining a batch comment using the Function Arguments dialog

You can define a custom comment to be used for data submission batches in the Longview data server repository by completing the function parameters in the Function Arguments dialog.

To define data to be submitted:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVBATCHCOMMENT. The Function Arguments dialog opens.
3. Complete the following fields :

   Field	Description
   Comment	Enter the comment text to be used for the submission batch. The comment must not exceed 100 characters.

4. Click OK. LVBATCHCOMMENT:<Comment> appears in the worksheet cell, where Comment is the text enter in the Comment field. For more on submissions, see Submitting data using the Longview Add-In for Office.

Note: The LVBATCHCOMMENT function sets a custom comment for submissions on the worksheet where it is used. If multiple LVBATCHCOMMENT functions are present on the same worksheet, only the last one processed is applied. If no LVBATCHCOMMENT function is defined on a worksheet, the default submission comment is "Data Submission from {workbook name}.