HEY,

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 ??? -