Skip to main content
Solved

How to add thousand separator (comma) in Aurena

  • Oct 20, 2021 11:30 PM UTC
  • 8 replies
  • 1237 views

Dilan Senevirathne
Superhero (Partner)
Forum|alt.badge.img+14

Hi All,

 

Does anyone know the setting in Aurena where we can set thousand separator (comma). 
ex. 1,000,000.00
In IEE this can be done through regional setting.

But the customer us using only Aurena, 

Thank you.

Best answer by Bhagya Wickramasinghe

Hi @Tharaka Senevirathne,

Navigate to the account settings,

Under currency formatting, enable the use grouping option.


Before adding the setting the result would be,


After adding the setting the result would be,
 


​​​​​​​I hope this will sort out the issue!

If you think my answer helped to resolve your issue, please mark it as the best answer. So that it will be helpful for other peers.


Best Regards,
Bhagya

View original

8 replies

Forum|alt.badge.img+13

Hi @Tharaka Senevirathne,

Navigate to the account settings,

Under currency formatting, enable the use grouping option.


Before adding the setting the result would be,


After adding the setting the result would be,
 


​​​​​​​I hope this will sort out the issue!

If you think my answer helped to resolve your issue, please mark it as the best answer. So that it will be helpful for other peers.


Best Regards,
Bhagya


Dilan Senevirathne
Superhero (Partner)
Forum|alt.badge.img+14

HI @Bhagya Wickramasinghe 

Thank you so much for the quick response.


russellclayton
Sidekick (Customer)
Forum|alt.badge.img+4

This works for currency, but what about numeric values that exceed 999.99?


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • Feb 14, 2023 12:53 PM UTC

Hi, how can i replace empty spade by comma or dot?


ashenfdo
Sidekick (Customer)
Forum|alt.badge.img+8
  • Sidekick (Customer)
  • Mar 9, 2023 10:39 AM UTC

Hi Does any one know how can we add this grouping function on for all the end users at once? 


SaraCrank
Sidekick (Customer)
Forum|alt.badge.img+10
  • Sidekick (Customer)
  • May 4, 2023 6:29 PM UTC

@ashenfdo - Did you figure this out? We need to do the same. 


ashenfdo
Sidekick (Customer)
Forum|alt.badge.img+8
  • Sidekick (Customer)
  • May 5, 2023 6:42 AM UTC

Hi @SaraCrank  not from client side, we are planing to write a script to enable this, you can find this value in user profile

 


Forum|alt.badge.img+3
  • Sidekick (Customer)
  • Mar 13, 2025 5:36 PM UTC

To do this retroactively I have created an xml file with this setting. It can be imported in bulk to Solution Manager>Users and Permissions>User Profile>Explore Profile>Profiles and does not overwrite any current settings in the profile.