Formula Help

[AussieRob]

I am having a bit of trouble with this formula, any ideas would be greatly appreciated.

Expr1: Sum(IIf([year]<2010,[so2_cost]/(610-17*([year]-2004))) Or (IIf(([year]<2019 And [year]>2009),[so2_cost]/(1126+90*([year]-2010)))))

The 'if' before the 'or' works fine, but when I add the second bit it just gives me -1 for everything which is not correct.

Thanks for your help on this one.

Rob

 

[Norie]

Rob

What is the formula actually meant to do?

 

[AussieRob]

I know the cost associated with 1 ton of SOx emissions and I know total emissions costs, but I don't actually know the quantitiy of the emissions (which is the goal).

Now in the period 2004 to 2010 the price falls from $610/t to $525/t, and given that this is a rough working model, I assume that the fall is constant at $17 per year. So we can do the calculation:

total cost / cost per unit

which should back out the number of units.

In the second section I am trying to do a similar thing but for the period 2010 to 2018 and with difference price assumptions.

Does that make sense?

 

[Philem]

Hullo. Try this:

Expr1: Sum(IIf([year]<2010,[so2_cost]/(610-17*([year]-2004)), IIf(([year]<2019 And [year]>2009),[so2_cost]/(1126+90*([year]-2010)))))

Not sure about the paren matches, but this should get you close.
HTH
P