Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANice beginner challenge.
Remember.. SELECT tool Char to INT conversions will truncate the value (59.9 becomes 59).
While a formula tool with Tonumber will automatically round the value (59.5 becomes 60)
So you may encounter data discrepancies if you use the Select tool data type conversion (which you really only should use when converting from integer values stored as strings to integer values stored as integer types).
As in this Challenge, all values which incidentally ROUND UP by the ToNumber function, will be different than values converted by the SELECT tool.
EG: 59.7 will become 60 (Tonumber) while 59.7 turns to 59 (Select tool). That is not a problem for all values that are rounded down though as 59.4 becomes using either SELECT tool or Tonumber.