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?