jQuery UI Widgets Forums Grid Sum

This topic contains 3 replies, has 2 voices, and was last updated by  Dimitar 10 years, 10 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Sum Posts
  • Sum #52134

    deliator
    Participant

    sum is not exact when ! aggregate …

    maybe is it a localization prob ?

    var localizationobj = {};
     localizationobj.currencysymbol = "€";
     localizationobj.decimalseparator = ",";
     localizationobj.thousandsseparator = ".";
     $("#jqxgrid").jqxGrid('localizestrings', localizationobj);

    and for the sum :

    { text: 'Montant', datafield: 'mt', width: 120, cellsalign: 'right', cellsformat: 'f2', aggregates: ['sum'] }

    result :

    the values in column Montant are correctly formatted (i.e. 1.456,75 or 54,50) but the sum is 1,475.47 …

    other question, is it possible to format the sum label ?

    Thx

    Marc

    Sum #52140

    Dimitar
    Participant

    Hello Marc,

    You can change the appearance of aggregates and labels by using aggregatesrenderer.

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

    Sum #52144

    deliator
    Participant

    Hi Dimitar,

    I mean if i just want to labelize ‘sum’ to ‘Total’ with using a function … by the way thanks for the answer

    Marc

    Sum #52147

    Dimitar
    Participant

    Hi Marc,

    I understood you earlier and indeed aggregatesrenderer is a suitable for this. In the demo notice the name variable in the aggregatesrenderer definition of one of the columns.

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.