Incorrect Total showing for one expression

[sridhar_sigired]

Hi,

Please find the attachment for reference. There is simple data related to Call center, a call can be responded, disconnected or IVR disconnect (any one can be possible), when call center has holiday responded+disconnected will be zero, but may be IVR disconnect can have value (customer may call without knowing about holiday and got disconnected in IVR).

Now at these kind cases, i have created one extra field.

If(Aggr(Sum (RespondedCall)+Sum (DisconnetCall),Date)=0, 0, Sum([IVR DisconnetCall]))

For this Total is showing incorrectly, can you please see this and help me.

Thanks.

[antoniotiman · Accepted solution]

Hi,

try

Sum(Aggr(If(Sum (RespondedCall)+Sum (DisconnetCall) <> 0,Sum([IVR DisconnetCall])),Date))

Regards,

Antonio