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

      001

      003

       

      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)

      Best,Brad