Difference between NUMC and number

[Former Member]

Hi

While creating keyfigures,just wondering whats the difference between Number and NUMC?

Regards.

[Former Member · Accepted solution]

Hi Simon,

NUMC is a character datatype . It can be used for telephone numbers , pincodes,etc. and cannot be used in mathematical calculations.

NUM can have numbers only and can be used in calculation as well.

Regards,

Arpit

[Former Member]

Hi Simon,

As said above, the NUM type is DEC and can be used for calculation or amount field with comma and +/- sign whereas NUMC type allows only numbers and cannot be used for calculations.

Regards
Sai

[Former Member]

Hi Simon,

The NUMC data type:

Stores data in a defined length format with leading zeroes

Does not allow decimal values

Does not allow characters

Has no restriction on length of the data

NUMC data type has the following restrictions.

-The NUMC data type is not supported for business collection JOIN fields.

-Business framework does not distinguish between the values such as 0012, 012, 12 for a NUMC data type attribute. As a result of this, the AttributeChanged event does not occur while setting values for the attribute.

-The specific search criterion, “<value>*”, is not supported on the NUMC data type attribute. For example, “123*”.

Where as Number stores can be used to perform calculations and does not have above restrictions.

Regards,

Harish.

[Former Member]

Does that mean number of number can be used in calculations and number of type NUMC cannot be used in calculations as it is stored as CHAR format and can also take characters?

[Former Member]

Number accept only numerics.

[former_member186445]

NUMC is a char existing only of figures (0-9)

number is a figure of type i or p...