Page 1 of 1

Fetch the current data but with 3 steps between.

Posted: Mon Jan 05, 2009 11:41 am
by haruki
If I have a graph and I only want to fetch the data from it each third steps. what kind of function could do this?

Example..

Graph
1=5
2=3
3=8
4=3
5=2
6=21
7=8
8=6
9=19

This means i want to get the following result
0, 0, 8, 0, 0, 21, 0, 0, 19 (each third step, get value from graph).

Anyone?

Sincerely,
Peter

Posted: Mon Jan 05, 2009 12:02 pm
by Administrator
Have a look at the modulo function, and then use an IF THEN ELSE statement. Using a combination of the two you can do this quite easily.

Hope this helps.

Tony.

Posted: Mon Jan 05, 2009 1:23 pm
by haruki
Hm, could you give me an example how you mean?

Posted: Mon Jan 05, 2009 1:42 pm
by haruki
Nevermind, got it to work.
Thnx..

IF THEN ELSE(MODULO(Time, 4)=0, X, 0)