SumIf Functionality...

[davehazle]

Hey gang,

I am attempting to achieve in Filemaker, something that is rather simple in softwares like Excel. I have a table with sales figures for a group of sales people (over 200) that I import sales data into weekly. I tag this data using a date token (1252010 for example would be January, 25th 2010). I am trying to get the database to spit out a total for sales revenue when the date is equal to 1252010 (week 1 of our year).

The desired outcome is to be able to display total sales by week in a separate table. This database is quite meaty so suggestions on how to restructure probably wont be the best solutions.

Any help would be appreciated.

[mr_vodka]

Why not just use a subsummary report grouped by datetoken?

[nathanlds]

sumif = case, case = sumif. To use it as excel, use the calculation:

case (what.you're.trying.to.test = what.it.should.equal ; sum (what.field.it.should.sum))

This way, IF whatever you're trying to test equals whatever field or value it should equal, that will sum the fields where it is equal. This is different than general Excel or other spreadsheet behavior where a similar "if" function would sum the entire column instead of just what you wanted it to sum. It behaves differently because it's database software and not a spreadsheet.

I wish some forum would've told me this before I spent 3 days trying to figure it out.

Enjoy!

Edited February 19, 2010 by Guest

[comment]

I am afraid it doesn't work that way.

[nathanlds]

well it's working for me

[comment]

We are probably not talking about the same thing (hard to tell from your description what exactly you are summing, under what conditions). Why don't you post a simple file showing your method?