Expand my Community achievements bar.

SOLVED

Problem with Adding numbers in two field

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

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

 

Thanks,

-Jon

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi,

 

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

 

Thanks,

-Jon