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

       

      sum(If(Sales='0',Planned,Sales))

       

      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

       

       

      BR

      Jayanthan