Joined: 19 Mar 2019
Location: United States
Online Status: Offline
Posts: 7
Topic: Next Value from Previous Formula Posted: 10 Apr 2019 at 1:15pm
Hi everyone, I'm having to create a mock crosstab and each "cell" (drawn only) contains a formula.
I would like to create a formula that looks the previous formula to its left either by name or position, and give me the next value from that original formula.
So Formula 1 shows record #128. I want formula two to look at 1 and its 128 and give me #129.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 11 Apr 2019 at 6:25am
So not really knowing the data I would suggest you think of this in a slightly more simple fashion.
If you can consistently determine a value that is in the "first cell" then second cell should just be that same formula "+1". Don't bother trying to reference the first cell, just use the same formula again with a "+1".
You clearly will need to move from a string to an int to do that but I think logically it is fine.
Again, I don't know your data at all but maybe something like:
if {?Starting Cell} = '3-4-A'
then
tonumber({ORDTASK.ORDNO}) + 1
Joined: 19 Mar 2019
Location: United States
Online Status: Offline
Posts: 7
Posted: 11 Apr 2019 at 6:29am
Thank you!
Except that won't work... The Ordno(sample id) is a string so adding the +1 does not give me what I need. It's almost like I need to assign a number value to the ID's and then call those but show what they represent - in my case a string value. This has made my brain hurt for days now and I'm starting to think it can't be done.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
