Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: CBDSV on 29 Nov 2018 03:02:05 PM

Title: Format table column in dashboard as currency?
Post by: CBDSV on 29 Nov 2018 03:02:05 PM
Hello,

Wondering how I can display an Amount value in a dashboard in currency format, it is in currency format in the data source ($.1,848.15) but shows as 1,848.15 in the dashboard.

Also wondering if there is an easy way to create a custom order for column sorting (Ex. I want sort ascending to sort column "Month" as Jan, Feb, Mar, etc...)
Title: Re: Format table column in dashboard as currency?
Post by: CBDSV on 03 Dec 2018 10:59:48 AM
bump?
Title: Re: Format table column in dashboard as currency?
Post by: MFGF on 03 Dec 2018 11:04:17 AM
Quote from: CBDSV on 29 Nov 2018 03:02:05 PM
Hello,

Wondering how I can display an Amount value in a dashboard in currency format, it is in currency format in the data source ($.1,848.15) but shows as 1,848.15 in the dashboard.

Also wondering if there is an easy way to create a custom order for column sorting (Ex. I want sort ascending to sort column "Month" as Jan, Feb, Mar, etc...)

Hi,

This type of formatting is possible in Cognos Analytics 11.1.1 dashboards. I'm guessing you are on an older 11.0.x version?

Cheers!

MF.
Text only | Text with Images