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

# How To sum between dates based on certain Criteria?

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:

 Date Name Price Paid or not paid 01/01/2016 Tom 10 Paid 05/06/2016 Pete 20 07/06/2016 Tom 12 Paid 07/07/2016 Tom 11 01/01/2017 Pete 12 01/01/2017 Tom 10

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

• ###### 1. Re: How To sum between dates based on certain Criteria?

In your example table, is each row a different record?

If salaries are in another table, what does that have to do with "price" in this table?  (

I Want to sum Salaries For Workers, based on This:Is it paid or not.) What do you mean by that?

If each row in your table is a different record and you want the total of Price for a given name for all Paid (or all unpaid) records, you can perform a find for all Paid (or for all Unpaid) records, sort the records by name and use a summary field placed inside a sub summary layout part set to be "when sorted by name". To produce a subtotal for each person.

There are many other ways to get these subtotals so this is just one fairly simple way.

• ###### 2. Re: How To sum between dates based on certain Criteria?

Sorry,  It should be not Price, but Payment, just Quick Typing mistake Sorry for that.

Ok, but How to sum between my selected Dates?

• ###### 3. Re: How To sum between dates based on certain Criteria?

I have already answered that question. Just use "payment" where I used "price" in my last response.

If that doesn't work for you, please explain and provide as much info as you can about what you want to do as there are many ways to calculate these totals.

• ###### 4. Re: How To sum between dates based on certain Criteria?

Hi Again.

I want to be able to select in Layout Salaries these Fields:

Name

Start Date - from this date on wards will be calculated

End Date - till this date will be calculated Salaries

Then I want to make report To be able to print for each name individual report on what day what they have earned.