VALUE

In Infoveave, the VALUE function is used to retrieve the value of a specific field or column.

Applicable to

• Calculated Columns
• Expressions

Return Value

The VALUE function returns the value of the specified field or column. If the field or column does not exist or the value is NULL, the function will return NULL.

Remark

• The VALUE function is often used in conjunction with other functions to perform calculations, transformations, or filtering based on the values of fields or columns in the Datasource.
• The VALUE function is typically used within calculated columns or expressions to reference a specific field or column.

Syntax

VALUE(<expression>)

Example

Suppose you have a dataset with the following columns- PRODUCT ID, PRODUCT NAME, PRICE, and QUANTITY. You want to create a calculated column that calculates the total price for each product (PRICE* QUANTITY). You can use the VALUES function to access the Price and Quantity columns

VALUES(PRICE) * VALUES(QUANTITY)