Fixed decimal assigned in a formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to solve an issue regarding values that are required to be converted to a fixed decimal (20.5) which i have not had issues with however I have scenario where I have and IF statement that is required to output the Fixed Decimal or a String value, as there is a conflict of data types i can not get the fixed decimal value as it reverts back to the original value (non 5 decimal places) if I change it to string to accommodate the string value
Is there a way to convert a value to a Fixed decimal using a formula instead of data type selection?
I have attached an example with an expected output column
Thanks in advance,
Ash
Solved! Go to Solution.
- Labels:
- Datasets
- Input
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @aka_ash ,
To accomplish that, you can use the ToString function where you can define the number of decimal numbers you want in your output.
ToString(x, numDec, addThousandsSeparator, decimalSeparator): Converts a numeric parameter to a string using numDec decimal places. By default, the period is used as the decimal separator.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator