tomosius

How To sum between dates based on certain Criteria?

Discussion created by tomosius on Apr 21, 2017
Latest reply on Apr 21, 2017 by 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

Outcomes