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!

Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀
    Accepted Answer

    CASE statement?

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

Answers

  • MartinB
    MartinB 🟑

    I badly overthink simple solutions from time to time.

    Β 

    Thanks!

This discussion has been closed.