4 Replies Latest reply: Jun 15, 2016 4:29 AM by Nizam HM RSS

    calculate field in load editor

    lingling Guo

      Hi, I have problem with create new field in the load data editor

       

      Capture.PNG

      Capture.PNG

       

      I would like to have a field to calculate if the KPIs performance exceed the target by more than 10 %, the following is what i try to do, but it fails.

       

      AdditionTable:

      Load

        "KPI(s)",

          if(((Sum({$<Types={'Performance'}, Months={'1/12/2015'}>} KPIValue) - Sum({$<Types={Target}, Months={'1/12/2015'}>} KPIValue))/Sum({$<Types={Target}, Months={'1/12/2015'}>} KPIValue))>=0.1, ('Yes'), ('')) as "MoreThan10%"

      Resident KPIDetails;