Formula Examples

{
  "formulas": {
    "commonRpn": "function(info){ var value = info.item['occ']*info.item['det']*info.item['sev']; return value?value:null;}"
  }
}

{
  "id": "rpn",
  "header": "RPN",
  "type": "int",
  "formula": "commonRpn"
}

{
  "formulas": {
    "commonRpnNew": "function(info){ var value = info.item['occNew']*info.item['detNew']*info.item['sevNew']; return value?value:null; }"
  }
}

{
  "formulas": {
    "commonRpn": "function(info){ var value = info.item['occ']*info.item['det']*info.item['sev']; return value?value:null;}"
  },
  "cellDecorators": {
    "rpn": "function(info){ var val = info.value; $(info.cell).toggleClass('boldCol', true ); $(info.cell).toggleClass('rpn1', val>0 && val <= 150 ); $(info.cell).toggleClass('rpn2', val > 150 && val <= 350); $(info.cell).toggleClass('rpn3', val > 350);}"
  },
  "styles": {
    ".boldCol": "{font-weight:600;}",
    ".rpn1": "{background-color: #eaf5e9 !important;color: #1d5f20 !important;}",
    ".rpn2": "{background-color: #fff3d2 !important; color: #735602 !important;}",
    ".rpn3": "{background-color: #f8eae7 !important;color: #ab1c00 !important;}"
  }
}

{
  "formulas": {
    "riskValue": "function(info){ var sev = info.item['severity']; var prob = info.item['probability']; if(!sev || !prob) return null; if(sev >= 8 && prob >= 6) return 'Unacceptable'; if(sev >= 5 && prob >= 4) return 'Further Investigation'; return 'Acceptable'; }"
  }
}

{
  "formulas": {
    "asilLevel": "function(info){ var s = info.item['severity']; var e = info.item['exposure']; var c = info.item['controllability']; if(!s || !e || !c) return null; var score = s + e + c; if(score >= 9) return 'ASIL D'; if(score >= 7) return 'ASIL C'; if(score >= 5) return 'ASIL B'; if(score >= 3) return 'ASIL A'; return 'QM'; }"
  }
}

{
  "formulas": {
    "autoTitle": "function(info){ var h = info.item['hazardousSituation']||''; var harm = info.item['harm']||''; if(!h && !harm) return null; return h + ' - ' + harm; }"
  }
}

{
  "formulas": {
    "uniqueChars": "function(info){ var rows = risksheet.ds.getMasterRowsByColumnValue(info); var vals = []; for(var i=0; i<rows.length; i++){ var v = rows[i]['processChar']; if(v && vals.indexOf(v)===-1) vals.push(v); } return vals.length ? vals.join(', ') : null; }"
  }
}

{
  "formulas": {
    "totalRisk": "function(info){ var rows = risksheet.ds.getMasterRowsByColumnValue(info); var total = 0; for(var i=0; i<rows.length; i++){ total += rows[i]['riskScore']||0; } return total > 0 ? total : null; }"
  }
}

{
  "formulas": {
    "combinedLink": "function(info){ var id = info.item['linkedId']||''; var title = info.item['linkedTitle']||''; if(!id) return null; return id + ': ' + title; }"
  }
}

{
  "cellDecorators": {
    "conditionalLock": "function(info){ if(info.item['approvalStatus'] === 'approved'){ info.item['systemReadOnlyFields'] = info.item['systemReadOnlyFields'] || []; info.item['systemReadOnlyFields'].push('severity','occurrence','detection'); } }"
  }
}

{
  "headers": {
    "rowHeader": {
      "renderer": "rowHeaderRpnNew"
    }
  },
  "cellDecorators": {
    "rowHeaderRpnNew": "function(info){ var val = info.item['rpnNew']; $(info.cell).toggleClass('rpn1', val>0 && val <= 150 ); $(info.cell).toggleClass('rpn2', val>0 && val > 150 && val <= 350); $(info.cell).toggleClass('rpn3', val>0 && val > 350);}"
  }
}

## risksheetTopPanel.vm
#set($matrixData = $doc.getOldApi().getValue('riskMatrixConfig'))
<script>
  var riskMatrix = JSON.parse('$matrixData');
  function lookupRisk(info) {
    var key = info.item['severity'] + '_' + info.item['probability'];
    return riskMatrix[key] || 'Not Evaluated';
  }
</script>

{
  "formulas": {
    "riskFromMatrix": "function(info){ return lookupRisk(info); }"
  }
}

{
  "formulas": {
    "commonRpn": "function(info){ var value = info.item['occ']*info.item['det']*info.item['sev']; return value?value:null;}",
    "commonRpnNew": "function(info){ var value = info.item['occNew']*info.item['detNew']*info.item['sevNew']; return value?value:null; }"
  },
  "cellDecorators": {
    "rpn": "function(info){ var val = info.value; $(info.cell).toggleClass('boldCol', true); $(info.cell).toggleClass('rpn1', val>0 && val<=150); $(info.cell).toggleClass('rpn2', val>150 && val<=350); $(info.cell).toggleClass('rpn3', val>350); }",
    "rowHeaderRpnNew": "function(info){ var val = info.item['rpnNew']; $(info.cell).toggleClass('rpn1', val>0 && val<=150); $(info.cell).toggleClass('rpn2', val>0 && val>150 && val<=350); $(info.cell).toggleClass('rpn3', val>0 && val>350); }"
  },
  "styles": {
    ".boldCol": "{font-weight:600;}",
    ".rpn1": "{background-color: #eaf5e9 !important;color: #1d5f20 !important;}",
    ".rpn2": "{background-color: #fff3d2 !important;color: #735602 !important;}",
    ".rpn3": "{background-color: #f8eae7 !important;color: #ab1c00 !important;}"
  },
  "headers": {
    "rowHeader": { "renderer": "rowHeaderRpnNew" },
    "columnHeader": { "height": 32 },
    "columnGroupHeader": { "height": 32 }
  },
  "columns": [
    { "id": "sev", "header": "S", "type": "rating:severity", "headerGroup": "Initial Risk" },
    { "id": "occ", "header": "O", "type": "rating:occurrence", "headerGroup": "Initial Risk" },
    { "id": "det", "header": "D", "type": "rating:detection", "headerGroup": "Initial Risk" },
    { "id": "rpn", "header": "RPN", "type": "int", "formula": "commonRpn", "cellDecorator": "rpn", "headerGroup": "Initial Risk" },
    { "id": "sevNew", "header": "S", "type": "rating:severity", "headerGroup": "Revised Risk" },
    { "id": "occNew", "header": "O", "type": "rating:occurrence", "headerGroup": "Revised Risk" },
    { "id": "detNew", "header": "D", "type": "rating:detection", "headerGroup": "Revised Risk" },
    { "id": "rpnNew", "header": "RPN", "type": "int", "formula": "commonRpnNew", "cellDecorator": "rpn", "headerGroup": "Revised Risk" }
  ]
}