Flexmonster Demo - calculated values restoration

by Iryna Kulchytska

HTML

<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>

JavaScript

var jsondata = [{
    "Color": "green",
    "M": "September",
    "W": "Wed",
    "country": "Canada",
    "state": "Ontario",
    "city": "Toronto",
    "Price": 174,
    "Quantity": 22
  }, {
    "Color": "red",
    "M": "March",
    "W": "Mon",
    "Time": "1000",
    "country": "USA",
    "state": "California",
    "city": "Los Angeles",
    "Price": null,
    "Quantity": 19
  }];

var report = {
  configuratorActive: false,
  data: jsondata,
  rows: [{uniqueName: "Color"}],
  columns: [{uniqueName: "[Measures]"}],
  measures: [{uniqueName: "Price", }, {uniqueName: "Quantity"},{
            "uniqueName" : "Formula #3",
            "name" : "Formula #3",
            "calculated" : true,
            "formula" : "sum('Quantity') / 2",
            "format" : "",
            "individual" : false,
            "availableAggregations" : [ ],
            "aggregation" : "none",
            "caption" : "Formula #3",
            "label" : "Formula #3",
            "originalCaption" : "Formula #3",
            "grandTotalCaption" : "Formula #3",
            "groupName" : "",
            "folder" : "",
            "type" : 1,
            "kpi" : "",
            "active" : true
          }, {uniqueName: "Formula #1", caption: "Formula #1", calculated: true, formula: "if( sum('Quantity') > 20 , sum('Price'), sum('Price') / 0 )", active: true}],
  formats: [{name: "", thousandsSeparator: ",", decimalSeparator : ".", decimalPlaces: 0, nullValue: "", infinityValue: "Over", divideByZeroValue: "DIV/0"}]
};

report.licenseKey = "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I";

flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", report, true);