9 Replies Latest reply on Dec 3, 2013 6:05 AM by kb-NetCom

    Math Function to sum only positive or negative Numbers

    kb-NetCom Level 1

      Good morning,

       

      I need to know, if I can select from several rows all the items which are positiv or all items which are negativ ...

       

      For a better understanding: in the formular are 20 rows which calculate if things are delivered or not. If not delivered and on the bill  -  it would be a value which has to be subtracted. The other way around, if there are goods which are delevered, but not on the bill, we have to add the price for it - positive numbers !

       

      I hope there is a function for this - otherwise it is a very uncomfortable if .. function.

       

       

      Thanks in advance.

       

      Klaus