Problem with Adding numbers in two field | Community
Skip to main content
Raaghuik1996
Level 2
Mar 18, 2020 1:05 PM UTC
Solved

Problem with Adding numbers in two field

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Mar 18, 2020 4:14 PM UTC

Hi,

 

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

 

Thanks,

-Jon

View reply

2 replies

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Mar 18, 2020 4:14 PM UTC

Hi,

 

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

 

Thanks,

-Jon

Translate
    Raaghuik1996Author
    Level 2
    Mar 19, 2020 7:14 AM UTC
    it works Thanks!!
    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...