AnsweredAssumed Answered

sum of cost amount calculation

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

Title

sum of cost amount calculation

Post

     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?

doubt.jpg

Outcomes