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:
=IF (F6 & G6 & H6 & I6 & J6 & K6 = “” , “No” , “Yes”)
Obviously this will be pasted down the line and that is currently what I’m doing but would like it to be done in SAP BI so I do not need to keep pasting it as I have many other reports to run.
I have tried using chat GPT to help out but that seems to give less than ideal solutions. One that seemed promising was:
= IF (ISNULL([Other column]), “Empty”, “not empty”)
My thought process was to focus on getting one column working and then I can add the other columns.
Ryan Mrozinski is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3