Cognos Analytics

 View Only
  • 1.  Have to display the symbol at same point in cognos11 in list report

    Posted Wed August 04, 2021 07:35 AM
      |   view attached
    Hi,

    Is it possible to display the dollor values with dollor symbol  at same point. Attached the screenshot for reference.

    Please help me on this.

    Thanks,
    Pavithra.

    ------------------------------
    Pavithra N
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Have to display the symbol at same point in cognos11 in list report

    Posted Wed August 04, 2021 08:11 PM
    Hi,

    In column Data Format property, select Currency. And in Pattern put $ ###,###.## ​

    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------



  • 3.  RE: Have to display the symbol at same point in cognos11 in list report

    Posted Thu August 05, 2021 03:28 AM
    Hi Jeam,

    Thanks for the input .But after giving the pattern also the symbol position is automatically adjusted based on the value and not displaying in same position in all rows.

    Regards,
    Pavithra.

    ------------------------------
    Pavithra N
    ------------------------------



  • 4.  RE: Have to display the symbol at same point in cognos11 in list report
    Best Answer

    Posted Thu August 05, 2021 05:10 AM
    Edited by System Fri January 20, 2023 04:19 PM

    Hi Pavithra,

    numbers are usually aligned to the right and thus the currency symbol position varies on value length. If you set horizontal alignment to left you should get what you ask for.

    Kind regards

    Sample currency formatting where Unit Price is aligned to the left while Unit Sale Price uses regular currency formatting or a pattern as described by Jeam.



    #CognosAnalyticswithWatson


  • 5.  RE: Have to display the symbol at same point in cognos11 in list report

    Posted Thu August 05, 2021 10:12 AM
    Horizontal alignment to left looks perfect ..Thanks for the solution.

    Regards,
    Pavithra.

    ------------------------------
    Pavithra N
    ------------------------------