Spliting amount column between round dollar amounts and uneven amounts
- 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
Hello!
I have created a macro that splits my amount column between round dollar amounts (like $100,$500,$1000,$4300) and uneven amounts (something like $ 743/$881/$29,064,etc). This macro works perfectly on my current data set. Attaching both my dataset (named round dollar amounts) and the macro.
However, when I try to use this macro on a different excel file (attached as dataset 1) that contains various other columns (like date, description, name, address and amount), I do not get the desired output. The amounts in the other dataset are in decimals and I want to filter out the decimal values and the rounded values. Would be great if anyone can help me with this. Thanks!
Solved! Go to Solution.
- Labels:
- Expression
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check if changing the datatype to FixedDecimal with 0 decimal places meets your requirement:
Output:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! But this rounding off the decimals (like rounding off 10.81 to 11).
I simply want it to filter the round dollar amounts (amounts that are a multiple of 10). Any help with this ?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How about adding this condition in the filter?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This works, appreciate your response! Thanks!
![](/skins/images/9AF25434D4F136B28264A96CA92E8A93/responsive_peak/images/icon_anonymous_message.png)