Whenever a calculation references data in a different table, the relationship linking the two tables will control the results returned by the calculation.
If I remember from your earlier thread correctly, you have this relationship between customer and coverage:
customer::CustomerID = Coverage::CustomerID
From the syntax shown, I think your calculation is defined in the Customer table. If so, Coverage:customer, and Coverage::month year will refer to the "first" related record in coverage, not a group of records specified by month and year. You'd have to build such matching into the relationship used by the calculation before you could do that. The Sum Function will then return the sum of FeatureCounter for all related records in Coverage, not the ones with the specified month. Thus this calculation either sums all related coverage records or none of them depending on whether the expression at the start of the If function evaluates as True or False.
Thanks for that!
Could i, instead of "If ( Type of Coverage = "Feature"; 1 )" in the coverage table, write "If ( Type of Coverage = "Feature"; month year )" which would write down the month and year only when the coverage is a feature? I could then, and I may need your help to do this, do some sort of count if statment in my table "coverage report"
what do you think?
ValueCount( FilterValues( List( coverage::Featurecount); Month1)) worked well as a count if