Forum Discussion

kati70's avatar
kati70
Regular Visitor
9 years ago

How can I convert negative value to zero

Hi,

 

I couldn't find a solution for this, so I really do hope that someone can support with this.

I have calculation where negative values should be converted to zero. Any ideas?

Thanks a lot,

-Kati

 

4 Replies

  • Baskar's avatar
    Baskar
    Resident Rockstar
    9 years ago

    Ya we can do . 

     

    If (  measure < 0 , 0 , measure )

     

     

    thats it. 

     

    let me know if any further help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I am wondering if this is the optimal way or if using the function max( measure, 0) performs quicker.

       

      (apologies for ressurecting an old thread!)

  • epieters's avatar
    epieters
    Frequent Visitor
    9 years ago

    Test if the number is negative, and if so, add the abolute value of that number.

    That will give you the zero.

     

    IF( [Number] < 0, [Number] + ABS( [Number] ), [Number] )

     

    Cheers,

     

    --Eric.

     

  • skasper's avatar
    skasper
    Responsive Resident
    9 years ago

    Have you tried adding a conditional column? See example below. Of course with your own column names. I am the first to admit that this is not very elegant, but it should work until you have a better solution.