Flexmonster Software License Agreement (“Agreement”) has been revised and is effective as of January 8, 2025.
The following modifications were made:
The modified version of Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after January 8, 2025, constitutes Licensee’s acceptance of the terms and conditions of the modified version of Agreement. If Licensee does not agree to any of these terms and conditions, they must cease using Flexmonster Software and must not download, install, use, access, or continue to access Flexmonster Software. By continuing to use Flexmonster Software or renewing the license or maintenance after the effective date of these modifications to Agreement, Licensee accepts and agrees to be bound by the terms and conditions of the modified Agreement.
addCalculatedMeasure(measure: Object)
[starting from version: 2.3]
Adds a calculated value.
Note You can add calculated value only for reports based on the "json"
, "csv"
, and "api"
data source types.
Learn more about calculated measures in this guide: Calculated values.
Property/Type | Description |
---|---|
measure MeasureObject | The object that describes the calculated value. Note that a calculated value must have the formula property defined. |
In the example below, we add the "Average Quantity"
calculated value. The formula is sum("Quantity")/count("Quantity")
. The calculated value will be added to the list of available measures and selected for the slice (active: true
):
let measure = {
formula: 'sum("Quantity")/count("Quantity")',
uniqueName: "Average Quantity",
caption: "Average Quantity",
grandTotalCaption: "Total Quantity",
active: true
};
pivot.addCalculatedMeasure(measure);