The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 indexing

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
zaskar Posted - 09/29/2010 : 06:27:39 AM
Hi, is there any way to adress the row index number within colums to do such an easy thing like: col(b) values= (col(a)i) - (col(a)i-1)...

so in this case to substract the former value i-1 of a column from the actual value i of the same or any other column?

many thanks in advance!
1   L A T E S T    R E P L I E S    (Newest First)
minimax Posted - 09/30/2010 : 04:56:47 AM
Hi Eric,

You may make use of the Set Column Values tool (a context menu when right click on a whole column).

Fill formula 
col(a)[i+1]-col(a)[i]


Or you can use a built-in function to do the calculation:
diff(col(a))


Hope it helps.

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000