Skip to Content

Formula calculated and preserved based on a key

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
    Add comment
    10|10000 characters needed characters exceeded

    • Follow
    • Get RSS Feed

    1 Answer

    • Best Answer
      Feb 20, 2017 at 05:10 PM

      Create formula

      @Key

      Global Stringvar key;

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

      Key;

      Ian

      Add comment
      10|10000 characters needed characters exceeded