Problem with Adding numbers in two field

[#1]

Hi,

In the attachment below Message Processed have the sum of Failed & Sent fields next to it...I can see data in Message Processed field only when other two fields have data....Need some help

Regards,

Raaghu

[Raaghuik1996 · Accepted solution]

Hi,

Are there nulls in the cols? Maybe try wrapping each with coalesce(), e.g. coalesce(failed, 0).

Thanks,

-Jon

[Raaghuik1996 · Accepted solution]

it works Thanks!!