How to use repeating fields in a calculation

[Miss A!]

I need to create a calculation in which if possible i want to use a calculation field text part, e.g calculation field repeats twice, 1st repetition has this data: "030 Service Adjusted Parking Brake" and 2nd repeat has: "less 2,5 settlement discount" - Now, in my calculation i want to use data in the 1st repetition that is "030 Service Adjusted Parking Brake" BUT only taking the three characters in the beginning that is "030" thereby multiplying that value by 1000.

 

How do i construct this calculation - and always i appreciate your help, Thanx

[Wim Decorte]

Since you only want to work with the first repetition, you can just reference the field like you would do with any other field.

 

And to get the first 3 characters, use "Left( YourField ; 3)"

 

A couple of pointers:

- don't use repeating fields for what you are describing,

- the fact that the field holds something that you then want to extract means that the data should be separate in two fields, one for "030" and one for the description 

[Miss A!]

Earlier figured something close about this kind:

 

Left(GetRepetition ( Remittance_Transport::Reference: ; 1 );3)

 

I am only feet wet with FM, so am still a thousand miles to go btw, i figured i no longer need to use that but i got an idea of calculating on repetition fields now :-) Thank you.