1 Reply Latest reply: Nov 14, 2016 6:27 PM by John Witherspoon RSS

    Changing Expressions to filter out values from calculation

    Edward Del Rincon

      HI there,

       

      I need some help with making a modification to a sales report.

       

      I need to change my expressions to remove any style with pallet=p from the calculation.

       

      How do I this properly?

       

      Thanks in advance.

        • Re: Changing Expressions to filter out values from calculation
          John Witherspoon

          If you mean eliminating rows with pallet = P:

           

          sum({<pallet-={'P'}>} Amount)

           

          If you mean eliminating any style for which any row of that style has pallet = P, I think this?

           

          sum({<style*=P({1<pallet-={'P'}>})>} Amount)

           

          Not that these are your expressions. Your expressions seem much more complicated in some cases, but it's the set expression that's important. In some cases there's no aggregation function at all. If you need the logic, use an only() expression around those expressions to add the set analysis.