This content has been marked as final. Show 2 replies
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.