Compare current row with value from the next

patebr · October 19, 2010 11:00AM

Hi,
I'm trying to write a formula that will add a duration to a datetime and then evaluate if the datetime of the next row is equal or bigger than my calculated value, how do I tell the formula to look at the datetime field of next row?

BR
Patrik

steve · October 19, 2010 11:15AM

Row indexing in formulas is not available in Omniscope yet. This is in part due to the potential for confusion between the unfiltered data (where the formulas are calculated) and the filtered data (which you typically look at). For example, a running total would not appear to run if you were filtering. We hope to address this in future.
You may be able to achieve the effect you want by hacking the SUBSET and SUBSET_SINGLETON functions to identify the cell you want.

steve · October 19, 2010 11:26AM

Please see the attached file for an example showing you how you can hack this up.

patebr · October 19, 2010 12:18PM

Thx alot that worked!

steve · January 25, 2011 12:18PM

Related post:
http://forums.visokio.com/discussion/comment/2166/#Comment_2166

(RUNNINGTOTAL function is now available in 2.6 b502+)

Welcome!

Categories

Ideas Parade

Tagged