Forum Discussion
Using ReplaceValue to conditionally replace a cell with a numeric value based on another column's value
I've seen lots of suggestions for when one is populating cells with text, but what if the new value is a number? In the example below, I filtered a table to a single row and requesting if the ticker...
I don't know why @Syndicate_Admin seems to be taking credit for the answer I posted. If you go to the linked forum where I answered this question, you will see that I edited that answer to a correct one, and also explained the error in your original code (which was pretty close). What @Syndicate_Admin copied here, although it works, should not be used as it is, in my opinion, bad programming technique. In the example that @Syndicate_Admin copied here, the null argument is irrelevant, as it never gets used; and the (x,y,z)=> refer to the three arguments normally passed to the Replacer.ReplaceValue function, by the Table.ReplaceValue function.