AnsweredAssumed Answered

sum of cost amount calculation

Question asked by AbinusJR on Mar 15, 2014
Latest reply on Mar 16, 2014 by philmodjunk


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?