title: Subtracting two fields in Kendo grid
body: <p>I am working with kendo grid and now I want to show a third column in kendo grid by subtracting two other fields. Is this possible in kendo grid. For eg: I want to show the field</p>
  
  <p>"Allocated"= "TotalAmount-TotalDepriciated"</p>
  
  <p>Code:</p>
  
  <pre><code>  $("#grid").kendoGrid({
          dataSource: DataSource,
          autoBind: false,
          scrollable: false,
          sortable: {
              allowUnsort: false
          },
          filterable: { mode: "row", style: "max-width:100px;" },
          groupable: true,
          pageable: {
              refresh: true,
              buttonCount: 5,
              pageSizes: GlobalPagingDDL
          },
          //rowTemplate: kendo.template($("#template").html()),
          dataBound: gridDataBound,
  
          columns:
              [
              //field: "Name", title: "Licensee", width: 200, filterable: { cell: { showOperators: false, suggestionOperator: "contains" } }, template: "&lt;a href='javascript:void(0)' onclick='RedirectToOrgDetail(&amp;quot;#:LicenseeId#&amp;quot; , &amp;quot;#:PublicName#&amp;quot; )' &gt;#:LicenseeName# &lt;/a&gt;" },
              { field: "AgreementName", title: "Agreement Name", width: 200, filterable: { cell: { showOperators: false, suggestionOperator: "contains" } } },
              {
                  field: "Count", title: "Related Agreement", width: 150,
                  filterable: { cell: { showOperators: true, suggestionOperator: "contains" } }
              },
              {
                  field: "Status", title: "Status", width: 150, filterable: {
                      cell: {
                          template: function (args) {
  
                              args.element.kendoDropDownList({
                                  dataSource: new kendo.data.DataSource({
                                      data:
                                      [
                                          { Status: "Approved" },
                                          { Status: "Pending" },
  
                                      ]
                                  }),
                                  dataTextField: "Status",
                                  optionLabel: "All",
                                  dataValueField: "Status",
                                  valuePrimitive: true
                              });
                          }, showOperators: false, suggestionOperator: "contains"
                      }
                  }
              },
              {
                  field: "Type", title: "Type", width: 150, filterable: {
                      cell: {
                          template: function (args) {
                              args.element.kendoDropDownList({
                                  dataSource: new kendo.data.DataSource({
                                      data:
                                      [
                                          { Type: "4" },
                                          { Type: "3" },
                                          { Type: "2" },
                                          { : "1" }
                                      ]
                                  }),
                                  dataTextField: "Type",
                                  optionLabel: "All",
                                  dataValueField: "Type",
                                  valuePrimitive: true
                              });
                          }, showOperators: false, suggestionOperator: "contains"
                      }
                  }
              },
  
  
  
  
  
              { field: "StartDate", title: "All Periods Start Date", width: 150, format: "{0:MM/dd/yyyy}", filterable: { cell: { showOperators: true } } },
              { field: "EndDate", title: "All Periods End Date", width: 150, format: "{0:MM/dd/yyyy}", filterable: { cell: { showOperators: true } } },
              { field: "TotalAmount", title: "Invoiced", format: "{0:c2}", footerTemplate: "$ #= sum # ", width: 200, filterable: { cell: { showOperators: false, suggestionOperator: "contains" } } },
              { field: "TotalDepriciated", title: "Allocated", format: "{0:c2}", width: 200, footerTemplate: "$ #= sum # " },
              { field: "Allocated", title: "Balance", format: "{0:c2}", filterable: { cell: { showOperators: false, suggestionOperator: "contains" } } },
              //{ field: "LastUpdatedDate", title: "Last Updated Date", width: 150, format: "{0:MM/dd/yyyy}", filterable: { cell: { showOperators: true } } }
              ]
      });
  </code></pre>