Challenge #469: Many-to-Many Like it Hot – Part 2
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the absence of a Percentage data type, is there a convention that says to show percentages as Int32 instead of decimal representation housed as Double?
Background: Instead of the decimal representation of 0.75 stored as Double, Percent Loved is multiplied by 100 and converted to Int32 to match 75 as shown in the Output File. Int32 (as stored in output file) at 4 Bytes saves 4 Bytes relative to the Double data type. An Int16, or even a byte (assuming all values will be positive), could store 75 with 2 bytes or even 1. As stored, 75 would be equivalent to 7500% and would require a division step if used in future calculations. I don't know what is most efficient, but I was just curious after changing the data types in my workflow to match the output. Maybe the data types in the output were arbitrary.
- 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
I feel a lot better about this one than my last one ha!
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution.
Formula Tool
[Percent Loved] = [Sum_Loved?] / [Count] * 100
[Spiciness] = Round([Spiciness], 0.01)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator