I wanted to concatenate this character '<' with a formatted numerical value such as thousands having a comma separator. I have tried multiple time and this formula worked for me:
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
(1).thumb.png.f8c9f921c64f52a6ccaa487392105c26.png)
Question
Flowers4Algernon
Hey!
I wanted to concatenate this character '<' with a formatted numerical value such as thousands having a comma separator. I have tried multiple time and this formula worked for me:
'<' + REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,[@field:testfield]),1), '.00','')
Happy to know some more formulas or workaround you guys have found!
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.