2 Replies Latest reply: Jun 5, 2013 6:45 AM by Sokkorn Cheav RSS

    if statement - set analysis

    Bradley Coyne

      hi i am trying to achieve the following

       

      I have three companies

       

      000 - Sweden

      001 - Norway

      003 - UK

       

      when calculating KPI incoming orders i have the following statement

       

      Sum(if(Bol_ID = 003,OrderRad.NettoBelopp*#Dat_O*OH.Kurs_FSG_act/2,OrderRad.NettoBelopp*#Dat_O))

       

      This is correct, when running for individual companies, but when i try to put together 000 and 003 i get the wrong values,

       

      is it possible to rewrite the statement whereby you always include 003 condition instead of having an if statement?

       

      Best,

      Bradley