0 Replies Latest reply: May 6, 2013 4:45 AM by Kristian König RSS

    Expression calculation

    Kristian König

      Hello,

       

      i would apreciate any help on this matter:

       

      I have 2 tables

       

      Table 1:

      PP, Artikl, SalesID, Salesamount

       

      Table 2:

      PP, SalesID, Salesamount, Refer on SalesID

       

      What i need:

       

      1. I need an new chart table with PP, salesamount, number of Sales IDs but only for sales IDs with sum(salesamount) >300

      2. Br. specifikacija should show Count(Distinct SalesIDs) that are >300 and SalesIDs that where refunded (the sum Salesamount should after the refund be still >300)

       

      F. ex. in the table "kalkulacija" you see that SALESID 868686 is a refund of InvoiceID "od Fakture" 11718-05-1. The formula needs to calculate for every salesID if there was a refund and then with it check the sum(salesamount) if >300. And the refund column should show -358.68 on SalesID 868664.

       

      I am sure the formula in table "result" is wrong and i am something missing.

       

      In the example PP NR: 211302 should have in table result. Promet 338.68 and Br. specifikacija 1.

       

      File attached, thank you in advance. I hope somebody can help me.