6 Replies Latest reply: Jul 3, 2014 2:44 PM by Jennie Elliott RSS

    Only show invoices with no cost

    Jennie Elliott

      I have a chart that I am working on and am having an issue on how to write the expression so that it only shows invoices and a specific detail type (INV|DetTypeID) with $0 as the INV|UnitLastCost. My expression is a follows:

       

      Sum({$<INV|VoidFlag={N},INV|DetTypeID={1,2,3,12,13,14}, Only(INV|UnitLastCost=0)>}INV|UnitLastCost)

       

      The returned value should be 0. If I run it as Only(INV|UnitLastCost=0), then it returns a -1...

       

      How can I write this correctly.

       

      Thanks in advance!