How can we calculate Custom row summary calculation conditionally?

[EPM Solutions]

Hello Team,

Requirement:
Exclude the records where Applicable column has No value from an avg(Custom row summary);

Can you please provide an example to calculate custom row summary for above requirement?

We have added an snippet in below URL;
Problem URL:
http://next.plnkr.co/edit/nCDCvzvt7eihojGl

[paramvir]

Please check this solution: https://stackblitz.com/edit/custom-aggregates

Code: [Select]

  var agg = pq.aggregate;
  agg.avgCustom = function(arr, col, rows) {   
    var vals = arr.filter(function(val, i){
      return (rows[i].applicable || "").toUpperCase() != "NO"
    })
    return agg.avg(vals, col)
  };