Skip to main content
Solved

I Need Thousand Seperator with comma at IFS Matrix Lobby

  • January 13, 2021
  • 4 replies
  • 530 views

0guz
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 64 replies

Hi all,

As i said i created a matrix lobby. But i see numbers without comma seperator at the element designer. So i tried to use to_char(value,’999,999,999,999’) format and that was success at the data source designer. But when i turn the element designer that changes has not processed and comma seperator doesnt work at element designer for some reasons.

Any usefull idea about this?

Best Regards.

with seperator at data source

 

without seperator at element designer

 

Best answer by servetsc

Hi Oğuz

You can try to set the column’s data type as currency in lobby data source;

 

 

Regards

 

Servet

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Forum|alt.badge.img+18
  • Superhero (Partner)
  • 364 replies
  • January 14, 2021

@0guz 

Have you tried setting your field to Currency, this works for me.  Although it doesn’t display the comma separator in the Data source view.

 

Within the element the comma IS displayed.

 

Regards

 

John

 

 


0guz
Hero (Employee)
Forum|alt.badge.img+10
  • Author
  • Hero (Employee)
  • 64 replies
  • January 14, 2021

Hi @johnw66 

Yes, I tried to change currency settings at the options but it was not work for me. So your experience about the Matrix lobby like my case or another element designer types?

 


Forum|alt.badge.img+5
  • 26 replies
  • Answer
  • January 15, 2021

Hi Oğuz

You can try to set the column’s data type as currency in lobby data source;

 

 

Regards

 

Servet


0guz
Hero (Employee)
Forum|alt.badge.img+10
  • Author
  • Hero (Employee)
  • 64 replies
  • January 15, 2021

Hi @servetsc ,

I tried so many things about this problem but sometimes the best solution in front of your eyes and the simplest😁

It works perfectly and i am embarrassing 😳

Best regards.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings