Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

Decimal problems with Excel Add-in

  • 1.  Decimal problems with Excel Add-in

    Posted yesterday

    IBM Planning Analytics for Microsoft Excel 2.0.103.5

    Using COGNAME/COGVAL formulas to retrieve a decimal number from a Power Cube.

    The decimal separator seems to be ignored as 
    54,8235294117647 becomes 5.482.352.941 and 37,5 becomes 375

    It does not seems to be an issue with regional settings because the problem is the same with '.' as the decimal separator.

    Is there any way of correcting this or retrieving the correct number?




    ------------------------------
    Dagur Egonsson
    ------------------------------


Related Content