Filling the Total Column with jqxgrid Multiplication

Question

Filling the Total Column with the jqxgrid Multiplier.

Hi there;

I want to multiply ItemQty and SinglePrice columns and write to TotalPrice column. How can I do that.

I tried to use the code in this link but it didn't work. The other columns show the data in the database.

var initFBListGrid=function(){
            source =
            {
                dataType: 'json',
                datafields: [
                    { name: 'Id' },
                    { name: 'OrderNumber' },
                    { name: 'LineNumber' },
                    { name: 'ItemNumber' },
                    { name: 'ItemDescription' },
                    { name: 'ItemQty' },
                    { name: 'SinglePrice' },
                    { name: 'Ixitem' },
                    { name: 'IsUrgentHTML' },
                    { name: 'StatusHTML' },
                    { name: 'IsApproved' },
                    { name: 'IsRejected' },
                    { name: 'LatestPurchasePrice' },
                    { name: 'PriceLevel' },
                    { name: 'DeliveryDate' },
                    { name: 'SupplierID' },
                    { name: 'SupplierName' },
                    { name: 'ProjectNumber' },
                    { name: 'ProjectName' },
                    { name: 'BuyerName' },
                    { name: 'PendingApproverName' },
                    { name: 'Company' },
                    { name: 'Currency' },
                    { name: 'HasAttachmentHTML' },
                    { name: 'Glco' },
                    { name: 'RequesterName' },
                    { name: 'ApproverName' }, 
                    {
                        name: 'TotalPrice',
                        formatter: function (cellvalue, options, rowObject) {
                            var ItemQty = parseInt(rowObject.ItemQty, 10),
                                SinglePrice = parseInt(rowObject.SinglePrice,10);
                            return $.fmatter.util.NumberFormat(ItemQty * SinglePrice, $.jgrid.formatter.currency);
                        }
                    }
                ],
                id: 'Id'
            };