How to change aggregate format

[Albert]

We need to change the format of aggregate functions in grid for money value in order to change it from $ to something else.

In order to change the format we tried to open this link but unfortunately its broken, please advice:

https://ej2.syncfusion.com/react/documentation/api/grid/aggregateColumn/#format-string---numberformatoptions---dateformatoptions

[Rajapandiyan Settu]

Hi Albert, 

Thanks for contacting Syncfusion support. 

   

Query: We need to change the format of aggregate functions in grid for money value in order to change it from $ to something else. In order to change the format we tried to open this link but unfortunately its broken, please advice : 

 

We are sorry for the inconvenience caused. We have logged a documentation task ”Need to resolve the broken Link for number formatting and date formatting in the Grid AggregateColumn”. It will be included in any of our upcoming release. To change the format of aggregate functions, we suggest you to set the format value in the `aggregateColumnsDirective` to achieve your requirement. For more information please refer the below code, sample links. 

render() { 

        return (<div className='control-pane'> 

        <div className='control-section'> 

          <GridComponent dataSource={data} allowPaging={true} pageSettings={this.pageSettings}> 

            <ColumnsDirective>              

                          ----------- 

            </ColumnsDirective> 

            <AggregatesDirective> 

                <AggregateDirective> 

                  <AggregateColumnsDirective> 

                  <AggregateColumnDirective field='Freight' type='Sum' format= "₹#.00"  footerTemplate={this.footerSum}> </AggregateColumnDirective> 

                  </AggregateColumnsDirective> 

                  </AggregateDirective> 

                  <AggregateDirective> 

                  <AggregateColumnsDirective> 

                    <AggregateColumnDirective field='Freight' type='Average' format='€#.0' footerTemplate={this.footerAvg}> </AggregateColumnDirective> 

                  </AggregateColumnsDirective> 

                </AggregateDirective> 

            </AggregatesDirective> 

          </GridComponent>      

      </div> 

      </div>); 

    } 

} 

Sample : https://stackblitz.com/edit/react-7hsnqy?file=index.js 

Documentation: https://ej2.syncfusion.com/react/documentation/common/internationalization/#number-formatting 

                              https://ej2.syncfusion.com/react/documentation/common/internationalization/#date-formatting 

Please get back to us, If you need further assistance. 

Regards, 

Rajapandiyan S.