Is there any way i can convert number to text format but still following the number format for comma

sarathchinta1

Unable to convert number to Text following comma format, Could anyone help me out of this problem?

 

Thanks in advance

 

 

 

 

rob_marshall

@sarathchinta1 

 

May I ask what exactly are you attempting to accomplish?  Why are you wanting to turn a number into a text?  I ask because that formula is nasty from a performance standpoint.

 

Rob

ChrisAHeathcote

@sarathchinta1 

Wozza, that is a crazy formula.

However, there are several hoops to jump through to return the correct text string.

I would echo @rob_marshall comment here and question why you need to do this. 

Here is my approach. 

I have split this out across multiple line items as there are several IF THEN ELSE statements that need to come together. The main issue I faced is ensuring that the reference used to pull in the thousands shifted depending on the length of the number. 

This example also only goes up to the millions.

 

 

 

 

 

 

 

 

sarathchinta1

For Requirement. But Problem has been solved. Thank you for your immediate response.

sarathchinta1

Thank you for immediate response. That would be great way to solve my problem.

MarkWarren

I would challenge that requirement!
You should try to avoid using text and converting numbers to text seems unnecessary.

Have a look at my recent article, Memory Usage From Text Concatenation  the same info applies here. Text manipulation creates a lot of memory overhead and uses (and throws away a lot of) memory in the calculation.

This can lead to problems at large scale model sizes.