How to display VDL-TABLE with entity values across scenarios, relative to the first selected scenario

Hi Alex, if all you need is to display differences with the first column then a custom render function may be your best bet.

<script>

function differenceFn(data, type, rowData, pos) {

if (type === 'display') {

if (pos.col > 1) {

var baseVal = rowData[1];

var diff = data - baseVal;

var diffToken = diff < 0 ? '-' : '+';

var percent = (100.0 / baseVal) * diff;

return diffToken + diff + ' (' + Math.round(percent) + '%)';

}

return data;

}

return data;

}

</script>

<vdl-table vdl-repeat-contents="=s,i in scenarios">

<vdl-table-column entity="NAGENTS" scenario="=i" editable="true" render="=differenceFn"></vdl-table-column>

</vdl-table>

This will display the differences similar to how you requested in your first request and doesn't require you to create your own table from scratch.

You would probably want to round differently and also use the name of the scenario in the table column heading attribute.

HTH, Joc