In SQL, the COALESCE(ValueA, ValueB, ...) function returns the first non-NULL value from the list of values provided. This would be a very useful addition to the functions supported in datasets. For example, let's say I needed the ability to track Term Start Date and Term End Date for Deals and Line Items. 95% of the time, all the line items in a deal have the same start and end dates, so inputting them at the Line Item level is just wasted effort and opportunity for error. Instead, it'd make sense to track that at the Deal level. But if it's important for the other 5% that different line items support different start/end dates, I'm stuck. I can't build the report to use the line item value if it exists, otherwise use the deal value. That's the sort of flexibility the COALESCE() function would enable.
...read more