SOLVED
Dividing Numbers
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
Ahasan13
7 - Meteor
‎01-25-2023
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I am trying to divide the numbers in the "Amount" and the "Balance" column by 1000. I want to do know how would I do this in the same column and/or create a new column?
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
3 REPLIES 3
binuacs
21 - Polaris
‎01-25-2023
08:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎01-25-2023
08:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Ahasan13 IF you wan to the output in new column you can use the same multifield tool with some update like below
nathanedwards
5 - Atom
‎05-08-2024
12:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can also simple formula tool:
Output Column = Amount
formula will be:
[Amount]/1000
Data Type = double
then do a comparable formula for your balance field.