1 Reply Latest reply on Apr 25, 2018 3:34 AM by Zhouyi Zhang

    Using calculated fields as a filter

    Sarah Chan

      Hi all

       

      I'm struggling to come up with a filter-like action/calculation below:

       

      Bascially, the null in C-land group should return 2 as shown under Land Group. However, only 2 was shown for the complex code as coded in the syntax below.

       

      How can I change the syntax below to make C-Land group return all 2s? Thank you!!