Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 10/29/2004(UTC) Posts: 1,394 Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
Krista, the error occurs because the formula is looking for at least 3 Major pivots to have occured . Depending on the amount of data loaded on a chart, you will then get these types of errors.
try your forrrmula without the major pivot price
2hp:= ExtFml( "PowerPivots.NthPivotPrice",-3 ,0 , 1);
2hp1:= ExtFml( "PowerPivots.NthPivotPrice",-3 , 1, 1);
2hp2:= ExtFml( "PowerPivots.NthPivotPrice",-3 ,2 , 1);
Amended formula
hp:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,0 , 1);
hp1:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,1 , 1);
hp2:= ExtFml( "PowerPivots.NthPivotPrice",-1 ,2 , 1);
1hp:= ExtFml( "PowerPivots.NthPivotPrice",-2 ,0 , 1);
1hp1:= ExtFml( "PowerPivots.NthPivotPrice",-2 , 1, 1);
1hp2:= ExtFml( "PowerPivots.NthPivotPrice",-2 ,2 , 1);
x:=If(hp<hp1 AND hp1<hp2 AND (hp1-hp)<hp2-hp1,1,0);
x2:=If(1hp<1hp1 AND 1hp1<1hp2 AND (1hp1-1hp)<1hp2-1hp1,2,0);
x+x2
|