8 Replies Latest reply: Oct 21, 2015 5:39 AM by Eliza FILIP RSS

    Left Join with NULL on Script

    Eliza FILIP

      Hello Team,


      I have two tables join with left join, and the null values must be filled with calculated values.

      I tried to use the ISNULL () function and ALT() function, but without success.

      I think it's from setting, but do not understand where is my mistake.

      My desired result it is:




      See the file attached.

      Could you please help?


      Thank you in advance for help!