Aylık
P:=(H+C+L)/3;
R1:=(2*P)-L;
R2:=P+(R1-S1);
R3:=H+2*(P-L);
S1:=(2*P)-H;
S2:=P-(R1-S1);
S3:=L-2*(H-P);
valuewhen(1.,MONTH()><Ref(MONTH(),-1),-1),P);
valuewhen(1.,MONTH()><Ref(MONTH(),-1),-1),R1);
valuewhen(1.,MONTH()><Ref(MONTH(),-1),-1),R2);
valuewhen(1.,MONTH()><Ref(MONTH(),-1),-1),R3);
valuewhen(1.,MONTH()><Ref(MONTH(),-1),-1),S1);
valuewhen(1.,MONTH()><Ref(MONTH(),-1),-1),S2);
valuewhen(1.,MONTH()><Ref(MONTH(),-1),-1),S3)
haftalık
P:=(H+C+L)/3;
R1:=(2*P)-L;
R2:=P+(R1-S1);
R3:=H+2*(P-L);
S1:=(2*P)-H;
S2:=P-(R1-S1);
S3:=L-2*(H-P);
valuewhen(1.,DAYOFWEEK()><ref(DAYOFWEEK(),-1),P);
valuewhen(1.,DAYOFWEEK()><ref(DAYOFWEEK(),-1),R1);
valuewhen(1.,DAYOFWEEK()><ref(DAYOFWEEK(),-1),R2);
valuewhen(1.,DAYOFWEEK()><ref(DAYOFWEEK(),-1),R3);
valuewhen(1.,DAYOFWEEK()><ref(DAYOFWEEK(),-1),S1);
valuewhen(1.,DAYOFWEEK()><ref(DAYOFWEEK(),-1),S2);
valuewhen(1.,DAYOFWEEK()><ref(DAYOFWEEK(),-1),S3)
iyi çalışmalar