sum of cost amount calculation
Hi All, I have attached the screenshot. most probably that image itself will explain my logic. let me paste the code i have used in the fields. Product Info1 field which hold "Y" & "N".
RemainingCosu2=If(Invoice Line Items::Product Info1 = GetAsText ("N"); Sum(Cost Total) - Invoice Line Items::VendPaid_total;0)
RemainingCosu1=If(Vendor Status="Partly Paid"; RemainingCosu2; 0). what should i do fix this issue?