ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on May 07, 2019, 04:30:49 pm

Title: Number-format issue in grid
Post by: EPM Solutions 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.
              },

Title: Re: Number-format issue in grid
Post by: paramvir on May 07, 2019, 06:28:52 pm

Please share a jsfiddle/ plnkr to check the issue.