I am trying to create a formula in a report in SAP BI where in one column I will have “Yes” or “no” based on if other 5 columns have a date in one of the cells in that row or not. This is a row on row basis so if any one of the cells in that row have a date then it will say “yes” in the counting column where the formula will take place. I have the formula in excel but need it here instead. The excel formula is: