Odd result

[jonathandienst]

Hi

I have a puzzle (for those who like them [:D]).

I have a model for a call center system for which an expression on a straight table/combo chart is producing odd results. First off, the set expression:

Sum({<CallDate={">=$(=MonthStart(Max(Total CallDate))) <=$(=MonthEnd(Max(Total CallDate)))"}>} Attempts)

works correctly, but I am trying to understand why this supposedly similar SumIf expression gets the wrong result:

Sum(If(CallDate >= MonthStart(Max(Total CallDate)) AND CallDate <= MonthEnd(Max(Total CallDate)), Attempts)).

CallDate is a field on the CallRegister table, Attempts is a flag field (1 or 0) on an analysis table linked 1:1 by CallID to the CallRegister. If Attempt is missing or zero, the call register entry was a "phantom" and not to be included in the count. See the figure for a snip of the table structure.

On a chart dimensioned by day of the month, for 1 August, the set expression gives a result of 3 (this is correct), while the SumIf gets 24.

Any thoughts as to why this is happening?[8-|]

Jonathan

[#2]

Hi Jonathan,

I'm trying to replicate this problem, but my Set analysis expression is giving me the same results as the normal expression.

hmmm.

It would be interesting to see why it is causing a difference with yours.