Fetch the current data but with 3 steps between.

haruki · Post by **haruki** » Mon Jan 05, 2009 11:41 am

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

Post by **Administrator** » Mon Jan 05, 2009 12:02 pm

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.

haruki · Post by **haruki** » Mon Jan 05, 2009 1:23 pm

Hm, could you give me an example how you mean?

haruki · Post by **haruki** » Mon Jan 05, 2009 1:42 pm

Nevermind, got it to work.
Thnx..

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