on ‎2025 Feb 18 7:42 PM
I am using Basic Syntax.
The following simple formula:
formula = "My Number: " & Round(1234.56,0)
yields:
My Number: 1,235.00
The Round function is rounding to zero decimals but also auto-formatting the result to add a comma and display two decimal places.
I tried:
formula = "My Number: " & Format(Round(1234.56,0), "#,##0")
but it doesn't look like Basic Syntax supports the Format function.
Request clarification before answering.
The equivalent function in Crystal is Cstr() or ToText().
The online help provides excellent details.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Once in CR Designer hit the F1 key to open the help file and search for Round:
Basic and Crystal syntax.
Round (x)
Round (x, #places)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 11 | |
| 6 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.