Problem with Adding numbers in two field | Community
Skip to main content
R
Raaghuik1996
Level 2
March 18, 2020
Solved

Problem with Adding numbers in two field

  • March 18, 2020
  • 1 reply
  • 2400 views

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.
Best answer by Jonathon_wodnicki

Hi,

 

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

 

Thanks,

-Jon

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
March 18, 2020

Hi,

 

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

 

Thanks,

-Jon

    R
    Raaghuik1996Author
    Level 2
    March 19, 2020
    it works Thanks!!
    Terms & ConditionsAccessibility statement

    Loading footer...