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?
Is it a numeric?
Try this expression
This returns the value before '.'.
If all your values are numeric, then you can use
to round off to the lower value.
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
Retrieving data ...