Negative value as 0

Reply
Highlighted
Major Blue Belt

Negative value as 0

Good day, I have a chart that based on the data, it can sometimes display a negative value in the percent trend line. I want this value when negative, to be set up as 0. Specifically, because of this week's situation in particular:negative.JPG

Any ideas on how can I make the negative be reflected as 0?

 

Thanks!


Accepted Solutions
Highlighted
Black Belt

CASE statement?

Case when sum(amount) <=0 then 0 else sum(amount) end


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Highlighted
Black Belt

CASE statement?

Case when sum(amount) <=0 then 0 else sum(amount) end


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Highlighted
Major Blue Belt

I badly overthink simple solutions from time to time.

 

Thanks!

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.