CODEWITHSUNDEEP
html-tablesapui5
Arun
Arun

Reputation: 1

SAPUI5 column summing

I developed a SAPUI5 table on frontend having 4 columns, now I need to show the total sum of 1 column. If anyone knows the code related to this please help me

Controller code

onInit: function () {
var oTable = this.byId("producttable"); 
oTable.addStyleClass("myCustomTable");  
    //column list item creation
    var oTemplate = new sap.m.ColumnListItem({
        cells: [
            new sap.m.Text({
                text: "{Plant}"
            }),
            new sap.m.Text({
                text: "{PlantDesc}"
            }), 
            new sap.m.Text({
                text: "{parts: [ {path: 'NetAmount'}, {path: 'currency'}],type: 'sap.ui.model.type.Currency',formatOptions: {showMeasure: false, maxFractionDigits: 0,roundingMode: 'away_from_zero'}}"
            })
         ]
    });
    var sServiceUrl = "/sap/opu/odata/sap/ZSALES_PLANT001_SRV/";
    //Adding service to the odata model
    var oModel = new sap.ui.model.odata.ODataModel(sServiceUrl, false);
    //Setting model to the table
    oTable.setModel(oModel);
    oTable.bindAggregation("items", {
        path: "/ZSalesheaderSet",
        template: oTemplate
    });

I am getting the following errors in console

sap-ui-core.js:187 Assertion failed: could not find any translatable text for key 'Total Sales-Yesterday' in bundle './i18n/i18n.properties' Failed to load resource: the server responded with a status of 503 ()

Upvotes: 0

Views: 1042

Answers (2)

Francesco Iannazzo
Francesco Iannazzo

Reputation: 626

If you have bound the table to a Odata or JSON model. Just Iterate over your items and sum the bound property of the column.

Upvotes: 0

Erch
Erch

Reputation: 625

getSum: function() {  

    var sum = 0, items = this.getView().byId("tableId").getItems();

    for (var i = 0; i < items.length; i++) {

        sum = sum + items[i].getBindingContext("urBoundModel").getObject().urColumn

    }

    return sum;


}

Upvotes: 0

Related Questions