We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to change aggregate format

Thread ID:

Created:

Updated:

Platform:

Replies:

147120 Sep 2,2019 11:10 AM UTC Sep 3,2019 12:07 PM UTC React - EJ 2 1
loading
Tags: Grid
Albert
Asked On September 2, 2019 11:10 AM UTC

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 [Syncfusion]
Replied On September 3, 2019 12:07 PM UTC

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>); 
    } 



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

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

Regards, 
Rajapandiyan S.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon