2 Replies Latest reply on May 15, 2013 12:58 AM by disabled_Luna.media

    How to sum only certain fields in a portal

      Hi there,

       

      I am quite new to FM 12 and modify the (german) "Invoice" demo that comes with FM 12. Hwat I like to do is to sum up some but not all of the invoice items (shown in aportal of an invoice) to give a discount an these. What I have are products than can be added to an invoice. One field in the product table indicates if that item is discountable or not. In the invoice I want to sum these discountable proucts and give the discount on these products - and then sum all products and add VAT on the (partly discounted) total.

       

      I am quite sure that there might be different ways to solve this problem - so please feel fre to indicate any.

       

      Thank you in advance, Luna