Filter vdl-table display to nonzero rows in FICO Insight application

Ok, I found a solution that uses the "row-filter" attribute of the vdl-table.

I modified my VDL file to:

<script>

function absAdd(a, b) {

return Math.abs(a) + Math.abs(b);

}

function nonZeroRow (rowData, indices, otherColumnsToIgnore) {

// return true if the sum of the data in the row is greater than zero

// the sum excludes some of the first columns (any index columns plus otherColumnsToIgnore)

// otherColumnsToIgnore should be an integer

var rowStart = indices.length + otherColumnsToIgnore,

    rowEnd = rowData.length;

return rowData.slice(rowStart, rowEnd).reduce(absAdd, 0) > 0;

}

</script>

<vdl-table page-mode="paged" show-filter="true"

           row-filter="=nonZeroRow(rowData, indices, 1)">

<vdl-table-column entity="Materials_Description"/>

<vdl-table-column entity="rawinput"

                  heading="=col.label"

                  vdl-repeat="=col in scenario.entities.Times">

<vdl-index-filter set="Times" value="=col.value"/>

</vdl-table-column>

</vdl-table>