10 Replies Latest reply on Apr 27, 2018 8:37 AM by Yuriy Fal

    Calculated field showing extra line of data

    paolo.raia

      Hi there,

       

      Wasn't sure how to explain this in the title!

       

      I have attached an example workbook with two tabs.

       

      The FULL DATA and RESULT tabs, along with the calculation, are shown below:-

            

       

      So if the TASK is equal to A, the RESULT should read as follows with one record row per acc no:-

      ACC NO.....CALCULATION 1

      123.............03-JAN-18

      456.............NA

       

      At present, the RESULT gives me an extra NULL row for acc 123 and a value of NULL for acc 456.  Acc 456 should read NA.

       

      Thanks in advance.