Author Topic: Number-format issue in grid  (Read 2390 times)

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Number-format issue in grid
« on: May 07, 2019, 04:30:49 pm »
Hello Team,

I created grid and the data source is from SharePoint list. I formatted columns as in currency format($##,###).

Some of them is coming in accurate format but some of them is not coming correct as shown in screenshot.

I am using the code as shown below. I need to format the all values with '$' Symbol. Please provide a solution for it.

             title: "Budget Adjustment (A2)",
              halign: 'center',
              align: 'right',
              dataType: 'float',
              sortable: false,
              width: 150,
              minWidth: 150,
              dataIndx: 'Budget_x0020_Adjustments',
              format: '$##,###',
              editable: false,
              summary: {
                type: "all" //use custom aggregate.
              },
« Last Edit: May 07, 2019, 04:49:15 pm by EPM Solutions »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Number-format issue in grid
« Reply #1 on: May 07, 2019, 06:28:52 pm »
Please share a jsfiddle/ plnkr to check the issue.