Skip to Content
0

Formula calculated and preserved based on a key

Feb 20, 2017 at 04:08 PM

37

avatar image
Former Member

I am trying to set up a formula/variable that takes on the value from a column based on a key and holds on to it until it hits another key value.


Here is an example. Key values are A, C. @Formula is the desired result based on Column values


    Column @Formula
    D --------- NULL
    A --------- A -- Key value
    F --------- A
    B -------- A
    C -------- C -- Key value
    B -------- C
    10 |10000 characters needed characters left characters exceeded
    * Please Login or Register to Answer, Follow or Comment.

    1 Answer

    Best Answer
    Ian Waterman Feb 20, 2017 at 05:10 PM
    1

    Create formula

    @Key

    Global Stringvar key;

    If Col1 in ['A', 'C'} then key:= col1;

    Key;

    Ian

    Share
    10 |10000 characters needed characters left characters exceeded