https://community.incorta.com/t5/dashboards-analytics-discussions/data-type-miss-match-in-if-case/m-p/6941#M843 <P>Hi,</P><P>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.</P><DIV><DIV><DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISNULL</SPAN><SPAN>(</SPAN><SPAN>Phoenix_STD.Coffeehouse_Facts.total_receipt_qty</SPAN><SPAN>)</SPAN><SPAN>,</SPAN><SPAN>&nbsp;</SPAN><SPAN>null</SPAN><SPAN>()</SPAN><SPAN>,</SPAN><SPAN>&nbsp;</SPAN><SPAN>Phoenix_STD.Coffeehouse_Facts.food_recvdqty_expdate</SPAN><SPAN>)</SPAN></DIV></DIV></DIV></DIV> Thu, 26 Mar 2026 22:20:06 GMT pgajjala 2026-03-26T22:20:06Z https://community.incorta.com/t5/dashboards-analytics-discussions/data-type-miss-match-in-if-case/m-p/6941#M843 <P>Hi,</P><P>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.</P><DIV><DIV><DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISNULL</SPAN><SPAN>(</SPAN><SPAN>Phoenix_STD.Coffeehouse_Facts.total_receipt_qty</SPAN><SPAN>)</SPAN><SPAN>,</SPAN><SPAN>&nbsp;</SPAN><SPAN>null</SPAN><SPAN>()</SPAN><SPAN>,</SPAN><SPAN>&nbsp;</SPAN><SPAN>Phoenix_STD.Coffeehouse_Facts.food_recvdqty_expdate</SPAN><SPAN>)</SPAN></DIV></DIV></DIV></DIV> Thu, 26 Mar 2026 22:20:06 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/data-type-miss-match-in-if-case/m-p/6941#M843 pgajjala 2026-03-26T22:20:06Z