Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Is it a numeric?
Ceil(Field)
Subfield(Field,'.',1)
Celambarasan
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.
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