Adding A Jqgrid Column That Is A Result Of Two Other Columns

I want to sum the column values of a jqGrid table.I have four columns in my jqGrid'SL', 'Item', 'Quantity', 'Rate','Amount',where Amount is the result of Quantity*Rate this multipl

Solution 1:

Please include in all your questions the information about the version of jqGrid, which you use (can use) and the fork of jqGrid (free jqGrid, commercial Guriddo jqGrid JS or an old jqGrid in version <=4.7). The solution can have depend on the information.

I suppose that the origin of your problem is the usage of custom formatter without specifying the corresponding unformatter function. See the documentation.

In general, it's better to replace custom formatter to jsonmap function, which return the calculated value based on the value of tow other properties. It allows for example to combine the jsonmap function with another formatter, for example with formatter: "currency", formatter: "integer" and so on.