4 Replies Latest reply on Apr 21, 2017 3:14 PM by tomosius

    How To sum between dates based on certain Criteria?

    tomosius

      Hi To all,

       

      This is my First Post and i am abit stuck in my Situation

       

      I want to calculate sertain fields between my set up dates and depending on few Criteria:

         

      DateNamePricePaid or not paid
      01/01/2016Tom10Paid
      05/06/2016Pete20
      07/06/2016Tom12Paid
      07/07/2016Tom11
      01/01/2017Pete12
      01/01/2017Tom10

       

      I Want to sum Salaries For Workers, based on This:

      Is it paid or not.

      Also Want to pay between certain dates if i select in my fields.

      I know it sounds strange, but i am a bit confused.

       

      At this moment i have table that i posted here, On another table where are salaries, it is connected my name, so in portal i can see just Exact Worker and on what day how much he earned and also it tells me it is paid or not. How to write function (although i bet i will need SCRIPT)

      I am not good with scripting

       

      Thanks for help