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?



Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀
    Answer βœ“

    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 ❀️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"


  • MartinB
    MartinB 🟑

    I badly overthink simple solutions from time to time.



This discussion has been closed.