AnsweredAssumed Answered

I'm stuck

Question asked by weedonpaul on Jan 3, 2012
Latest reply on Jan 5, 2012 by weedonpaul


I'm stuck


I've done something really obviouse, but i don't know what.

I am trying to count the occurance of a word in a field by date (month and year), over a 3 month period.

in one table called coverage i create a calculation field called month year with this calculation

"(MonthName ( Date of Publication  _dd_mm_yyyy_ )  & Year ( Date of Publication  _dd_mm_yyyy_ ))"

I also create another field to count the occurance of the word "feature" 

"If ( Type of Coverage = "Feature"; 1 )"

in another table called coverage report

i count the number of occurances by the if statment is to filter by companie and in this case all occurances in october (Month1)

"If ( (Coverage::Customer = Company) and (Month1 = Coverage::month year); Sum(Coverage::FeatureCounter );0)"

i do exactly the same line in 2 other fields but replace Month1 with Month2 and Month3 (November and December)

the problem is that the count is not right, I should get 2,1,1 respectivly but I get 0,0,4

Why is it counting them all in the december date? I can swap the order of the month1,2,3 so that December is 2 or 1 and december always has the total.

The only thing I can think of is that it has something to do with the fact that december is the date of the last entry in table "coverage"