merge subunit (1.1 to 1)

[#1]

Hi

I have two subunits in a departmeant. Unit 1.b and unit 1c. I want them, and the related data, to merge to Unit 1 so the enduser only see Unit 1 in the application. How can this best be done?

[CELAMBARASAN]

Hi,

     Is it a numeric?

     Ceil(Field)

     Subfield(Field,'.',1)

Celambarasan

[jagan]

Hi,

Try this expression

=Subfield(Field,'.',1)

This returns the value before '.'.

If all your values are numeric, then you can use

=Floor(FieldName)

to round off to the lower value.

Regards,

Jagan.

[#4]

The deparments are in both a field with depText with the full name written and depNr with a number. The enduser only sees the depText field but in set-analys I use the depNr