Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try adding ConsumptionFrom and ConsumptionTo as dimensions. There are several values per customer.
thanks for your answer. but adding ConsumptionFrom and ConsumptionTo as dimensions chances nothing.