Negative value as 0

MartinB

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:

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

 

Thanks!

jaeW_at_Onyx

CASE statement?

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

jaeW_at_Onyx

CASE statement?

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

MartinB

I badly overthink simple solutions from time to time.

 

Thanks!