3 Replies Latest reply: May 11, 2010 3:40 AM by Joachim Rogginer RSS

    How can elements be taken out of a field?


      Hi everyone,

      Is it possible to take elements out of a field and create new fields to do operations on those elements.

      Say there is a file as such:

      Forecast plan Customer Revenues (m)

      F1 Bob 2.3

      Mary 5.8

      F2 Bob 3.1

      Mary 4.7

      F3 Bob 3.6

      Mary 6.0

      Luke 1.3


      And it is necessary to find the deviations between F1, F2, and F3. How can new fields be created just for F1, F2, and F3 from the field "Forecast Plan"?

      Thank you in advance for your response.