Forum Discussion

tameemyousaf's avatar
tameemyousaf
Icon for Helper I rankHelper I
8 years ago
Solved

Filter Value of Measure

I have a measure that shows below values in grid.     "Stock Exc/Def" is not the column its a measure. I want to filter the values and want to get the values that are -ve. I don't want to us...
Need Help
  • gapage's avatar
    gapage
    8 years ago

    =IF (
        [Stock Exc/Def] < 0,
        [Stock Exc/Def],
        BLANK ( )
    )

gapage's avatar
gapage
Icon for Advocate I rankAdvocate I
8 years ago

=IF (
    [Stock Exc/Def] < 0,
    [Stock Exc/Def],
    BLANK ( )
)