Skip to main content
25 events
when toggle format what by license comment
S May 18, 2016 at 10:17 history bounty ended Joseph
S May 18, 2016 at 10:17 history notice removed Joseph
May 13, 2016 at 16:42 history edited 200_success CC BY-SA 3.0
added 82 characters in body; edited title
May 13, 2016 at 11:46 comment added Mast @Joseph Agreed. Fixed. Feel free to ask a new question with the improved code, linking back to this question. Welcome to Code Review!
May 13, 2016 at 10:06 comment added Joseph @Mast - Thanks, that's a fair point. I suggested an edit to 2 answers below to reflect this change (one was accepted). Perhaps it should be rolled back also?
May 13, 2016 at 10:03 comment added Mast I have rolled back the last edit. Please see What to do when someone answers.
May 13, 2016 at 10:02 history rollback Mast
Rollback to Revision 4
May 13, 2016 at 9:19 comment added Joseph @200_success - I definitely need to drink stronger coffee in the mornings...but yes, you're absolutely right in that it should be coalesce("Layer_1a_Score" = 2, 0.00)*2 + coalesce("Layer_1b_Score" = 2, 0.00)*2 + .... I have edited the question and the final code for 2 answers to reflect this (tested) minor correction.
May 13, 2016 at 9:11 history edited Joseph CC BY-SA 3.0
Corrected mistake
May 13, 2016 at 0:02 answer added 200_success timeline score: 5
May 12, 2016 at 18:48 comment added 200_success That makes a bit more sense than before. But do you actually mean coalesce(Layer_1a_SCORE = 2, 0.00)*2 + coalesce(Layer_1b_Score = 2, 0.00)*2 + ...?
May 12, 2016 at 17:01 history tweeted twitter.com/StackCodeReview/status/730805210935906304
S May 12, 2016 at 14:31 history bounty started Joseph
S May 12, 2016 at 14:31 history notice added Joseph Reward existing answer
May 12, 2016 at 14:30 vote accept Joseph
May 12, 2016 at 12:57 comment added Joseph @200_success - Funnily enough, there is a mistake. The coalesce()functions should be added together coalesce(Layer_1a = 2, 0.00)*2 + coalesce(Layer_1b = 2, 0.00)*2 + .... However, using both methods answered, this was easily solvable but thanks for making me check the code again ;)
May 12, 2016 at 9:33 comment added Joseph @200_success - Thank you, I've edited the question to include a screenshot of executing the code and the printout obtained =)
May 12, 2016 at 9:32 history edited Joseph CC BY-SA 3.0
Added sample output in response to comment
May 11, 2016 at 0:22 answer added scottbb timeline score: 7
May 10, 2016 at 22:55 comment added 200_success I am skeptical that this produces the final_formula that you intend. Could you edit the question to include some sample output?
May 10, 2016 at 22:12 history edited 200_success CC BY-SA 3.0
edited tags; edited title
May 10, 2016 at 16:30 answer added Peilonrayz timeline score: 8
May 10, 2016 at 14:51 history edited Joseph CC BY-SA 3.0
Edited title to make it more specific
May 10, 2016 at 14:22 review First posts
May 10, 2016 at 18:02
May 10, 2016 at 14:18 history asked Joseph CC BY-SA 3.0