I have a field with two numbers in it (nfield1) which are separated with a dash e.g. 19-20. I want to add these numbers together and take and average and post to another empty field (nfield2). Not sure how to do this...

Some imported records have the numbers in a format 19/20 - same thing.

Having obtained this av. number e.g. 19.5 - I wish to convert it to a number on a 100 pt scale e.g. in this case 99. Is this just a question of using the Substitute function?

Thx for any help.

Are these test scores over time? Can you expand on the what you are trying to do a little more.

What do these numbers mean? How are they related? Why do you have the two numbers in one field?

Try =

Let ( 

s = Substitute ( nfield1 ; [ "-" ; ¶ ] ; [ "/" ; ¶ ] )

;

Average ( GetValue ( s ; 1 ) ; GetValue ( s ; 2 ) )

)

or =

Evaluate ( Substitute ( nfield1 ; [ "-" ; "+" ] ; [ "/" ; "+" ] ) ) / 2

This will give you the 19.5 part. I didn't quite get by what logic it should become 99.

Edited May 7, 201015 yr by Guest