Negative value as 0

MartinB
MartinB Member
in Charting

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 Coach
    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"

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    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 Member

    I badly overthink simple solutions from time to time.

     

    Thanks!

This discussion has been closed.

Categories