2 Replies Latest reply: Mar 16, 2015 7:26 AM by rico hoffmann Branched to a new discussion. RSS

    Calculate of a new KPI doesn't work



      there are two tables Price and Payoff. I want to calculate the new KPI PriceCalc like

      if(ConsumptionFrom<=Consumption and Consumption<=ConsumptionTo, BasicRate+EnergyRate*Consumption,-999).


      I get only the value -999 for all CustomerID and don't know why.


      Best regards