Forum Discussion

astano05's avatar
astano05
Helper III
2 years ago

Remove Negative Values only in January

I have created the below 2 measure which work as expected.    MPG Sold YTD-LY Chg SUM = sumx(filter(Customer,[MPGs Sold YTD-LY Chg threshold]>0),[MPGs Sold YTD-LY Chg threshold]) New MPG Sold = [M...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

use MAX(0,[value])  to suppress negative values.

  • astano05's avatar
    astano05
    Helper III
    2 years ago

    This works to change the negative values to 0, but I want my measure to calculate only for positive outcomes. Using MAX, causes it to show 0 for all values