Problem with Adding numbers in two field

Raaghuik1996

18-03-2020

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

 

Raaghuik1996_0-1584536599787.png

Raaghuik1996_1-1584536677427.png

 

Raaghuik1996_2-1584536717151.png

Regards,

Raaghu

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

18-03-2020

Hi,

 

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

 

Thanks,

-Jon

Answers (0)