2 Replies Latest reply: May 17, 2013 10:04 AM by Celambarasan Adhimulam RSS

    If statement SUM calculation

    Bradley Coyne

      Hi I am trying to achieve the following.



      i have three companies






      000 and 003 share the same database, therefore i recieve double values when running the following sum for company 003. 001 is correct so no need to worry about that.


      what i want to do is half the amount for company 003 based on the following calculation.



      psuedo if(company = 003......), otherwise  ->



      Sum(OrderRad.ResterandeBelopp * #Dat_O * OH.Kurs_FSG_act)