Dynamic Formulas with functions

[mercury85]

.I am almost complete, but am on one last portion.  How could we create dynamic formulas..


                var formulaModel = ['r' + key, function (rd) { return rd.SERIES_TYPE === 'Forecast' ? rd[key]: undefined; }];

Trying this but no go so far...

Took the render off the colModel, and it looks like it is in teh render area...

  var colRenderObjCreate = {
                    title: key,
                    width: 150,
                    dataIndx: 'r' + key,
                    format: "##,###",
                    hidden: false,
                    nodrag: true,
                    align: "center",
                    cls: "date-col",
                    summary: {
                        type: "sum",
                        edit: false
                    },
                    render: function (ui) {
                    var rd = ui.rowData;
                        return (rd.SERIES_TYPE != 'Forecast' ?
                    pq.formatNumber(rd[key], ui.column.format) :
                    ui.formatVal);
                    }
                };


strangest thing is it is working only at the most child level...


Thank you

[mercury85]

Stupid me....

had the following on the hidden column....

                summary: {
                        type: "sum",
                        edit: false
                    }


with that said, is there a way to just sum at the child level?

[paramvir]

is there a way to just sum at the child level?

Please use groupModel.showSummary option. https://paramquery.com/pro/api#option-groupModel

e.g., if there is 3 level of grouping, summary can be shown in 3rd level only by

Code: [Select]

  showSummary: [ false, false, true ]