Linear interpolation

Mon, 13 Jan 2014 12:14:19 GMT

Hi,

I need your help to fix this expression that i am using to get the value of a known point x :

Here is the expression :

Sum({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack)))) <=$(=(max([Due Year]) ))"},

Elapse ={"=$(=(Min({1} Aggr(Min({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack)))) <=$(=(max([Due Year]) ))"},

Elapse ={">=$(=(max(Elapse)))"}>} Elapse),[Due Month],[Due Year]))))"}>}Sales_$(V_Currency))/1000

This expression shows an error but i cannot see where is it ?

My known point x i get it with this expession :

=Min({1} Aggr(Min({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack)))) <=$(=(max([Due Year]) ))"},

Elapse ={">=$(=(max(Elapse)))"}>} Elapse),[Due Month],[Due Year]))

Can you please help to fix it ?

Thanks

Re: Linear interpolation

Nicole-Smith — Mon, 13 Jan 2014 14:38:14 GMT

This is a duplicate post. Someone already replied here: Linear interpolation