11 Replies Latest reply: Aug 31, 2014 8:14 AM by Marco Wedel RSS

    Sum if  expression

      hi All



      Could you please confirm whether the below given expression is accurate




      Month     Sales,   Planned

      Jun           100       100

      Jul             150         100

      Aug             0            200


      Based on above sample data, i would like to calculate  cumulative sales  for  3 months


      Sum  all sales but if sales is equal to zero , then planned value should be aggregated


      Thus , total value for three months should 100+150+200 = 450