Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #334: Literacy Practice

cmoussa
8 - Asteroid

WF.png

 

robert-headington
8 - Asteroid

#334

Arran
8 - Asteroid

Awesome

JBevan89
8 - Asteroid

Solution attached

JaimeCollins
8 - Asteroid

solution

Bennu
8 - Asteroid

Nice 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.

 

Spoiler
WC_334.jpg