2 Replies Latest reply: Aug 19, 2015 1:38 PM by Massimo Grossi RSS

    Exclude negative Values from expression

    Shan Ahmed

      Hi,

       

      I have the expression to calculate the Units. But i am having some negative Units (Value) which i dont want to include in the calculation.

       

      =num((Sum({<Type = {'AB','CL'},

      [Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')


      How do i do this?

       

      Any help please?


      =num((Sum({<Type = {'AB','CL'}, Units -={},

      [Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')


      Thanks,

      Ahmed