6 Replies Latest reply: Apr 4, 2018 2:27 PM by Bradley Vespa RSS

    SUM sales if 2 conditions exist

    Bradley Vespa


      I'm attempting to show records where 2017 sales <=0 AND 2016 sales >=0. The data doesn't match up to what I can see when doing the same in excel. I'm sure there is a better way to write this (super new to this). Appreciate any guidance.


      My expression is as follows:



      [Consolidated Partner Name]  ={"=IF(SUM({<[Year]={2017}>}[Sales USD])<=0,IF(SUM({<[Year]={2016}>}[Sales USD])>=0.01,[Sales USD]))"}


          [Sales USD])