SOLVED
Adding Decimals to amounts
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ElizabethT
5 - Atom
‎09-26-2019
08:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My data set is coming as
54834
-32509
1
And I need it to read
548.34
-325.09
1.00
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
3 REPLIES 3
20 - Arcturus
‎09-26-2019
08:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That last one is odd.
[amount]/100
Is a formula that would work. You can make it conditional. If the only values not to divide by a hundred are those less than a hundred or other rule.
IIF([amount]>100,[amount]/100,[amount])
Cheers,
Mark
[amount]/100
Is a formula that would work. You can make it conditional. If the only values not to divide by a hundred are those less than a hundred or other rule.
IIF([amount]>100,[amount]/100,[amount])
Cheers,
Mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
17 - Castor
‎09-26-2019
08:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's an expression that can be used in a Formula tool to string-edit the input to achieve the desired result as a string:
Left(PadRight(tostring([Input]),3,'0'),
Length(PadRight(tostring([Input]),3,'0'))-2)
+"."+
Right(PadRight(tostring([Input]),3,'0'),2)
If you'd like to output this as a Fixed Decimal field, the attached example shows how you can add a "tonumber(' function and format the field accordingly.
‎09-26-2019
09:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That worked perfectly!
Thanks so much!
