Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Problem with Adding numbers in two field

Raaghuik1996
Level 2
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
Jonathon_wodnicki
Correct answer by
Community Advisor
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
Jonathon_wodnicki
Correct answer by
Community Advisor
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