https://communities.sas.com/t5/SAS-Enterprise-Guide/Computed-column-is-blank-in-SAS-EG-4-1/m-p/58003#M5986 Gross_margin = coalesce(Salary,0) - Coalesce(Expense1,0) - Coalesce(Expense2,0) - coalesce(Expense3,0) Wed, 27 Apr 2011 16:43:18 GMT DBailey 2011-04-27T16:43:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Computed-column-is-blank-in-SAS-EG-4-1/m-p/58002#M5985 Hello,<BR /> I'm joining 4 tables using a left join. 1 table has Salary by quarter (left table) and the other 3 tables have different expenses by quarter. I want to join them so that I could calculate: <BR /> <BR /> Gross margin = Salary - Expesne1 - Expense2 - Expense3 <BR /> <BR /> My gross margin works great if I have the same quarter match in all 4 tables. <BR /> <BR /> My gross margin turns blank whenever I don't have a match for that quarter in all 4 tables. It lists the Revenue and the expenses but it won't calculate gross margin. <BR /> <BR /> How do I fix it?<BR /> <BR /> thanks! Wed, 27 Apr 2011 16:03:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Computed-column-is-blank-in-SAS-EG-4-1/m-p/58002#M5985 MadCowKilla 2011-04-27T16:03:15Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Computed-column-is-blank-in-SAS-EG-4-1/m-p/58003#M5986 Gross_margin = coalesce(Salary,0) - Coalesce(Expense1,0) - Coalesce(Expense2,0) - coalesce(Expense3,0) Wed, 27 Apr 2011 16:43:18 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Computed-column-is-blank-in-SAS-EG-4-1/m-p/58003#M5986 DBailey 2011-04-27T16:43:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Computed-column-is-blank-in-SAS-EG-4-1/m-p/58004#M5987 This works great.<BR /> <BR /> Thank you very much. Wed, 27 Apr 2011 17:23:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Computed-column-is-blank-in-SAS-EG-4-1/m-p/58004#M5987 MadCowKilla 2011-04-27T17:23:55Z