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

      Hey,

       

      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