Skip to Content
avatar image
Former Member

Difference between NUMC and number

Hi

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

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 11, 2012 at 06:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2012 at 09:19 AM

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29, 2012 at 09:24 AM

    Number accept only numerics.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2012 at 06:21 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2012 at 07:29 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2012 at 07:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded