Hi,
I am trying to create a formula column with a simple CASE logic. Case when column 1 is NULL then NULL else column 2. Column 1 and column 2 are different data types. I tried the below and Incorta does not like null() being bullian and the column being DATE data types. Please let me now if there is a solution for this.
IF(ISNULL(Phoenix_STD.Coffeehouse_Facts.total_receipt_qty), null(), Phoenix_STD.Coffeehouse_Facts.food_recvdqty_expdate)
