2 Replies Latest reply on May 14, 2019 4:51 AM by Manoj Manogyaramasharma

    Net Sales Formula Error

    Pankaj Beniwal



      I am working on 2 Datasources Sales Data(Primary) and Returns Data(Secondary) and created a calculated field Net sales (i.e Sales Amount - Return Amount). Linked both files by 2 fields - Month/Year Date Part (Sales Date & Invoice Date Respectively) and Item name (Line Item in Data)

      (Monthwise Net sales TABLE ) but i am getting error if Returns Amount is Zero then it is giving net sales as zero - Other cases it is working fine. is this some formula error ??? -