How to set the number format of a scorecard column per cell?

[Former Member]

Hello,

I am using a scorecard component in my dashboard. The Problem is not all of the Values of my KPI's are of the number format currency, some might be a percentage, how could I solve this problem?

To clarify the problem I added a picture

[former_member184839]

Hi Franz,

Once you do this the scorecard automatically formats itself as in the spreadsheet. Map the formatted data to the scorecard.

P.S : You ll have top divide the number by 100, to show the percent symbol in there, else it d show you number multiplied with hundred. 38% ll be

3800%

Hope it helps.

Thanks,

Sara

[Former Member]

hi

As Mohamed Anas says you must first format the excel cell and set the cell format to percentage by right clicking on the cell and clicking on the % symbol. But in the Scorecard there will be no display of "%" symbol near the value though the value's format is in percentage. So near the text "Quality performance" give a "%" symbol to signify that it is a percent value and not a general number.

Hope this helps.

Regards

Varshini.

[Former Member]

Scorecard allows you to format only by columns.

You can use your spreadsheet formatting by changing the formats for each cell.

Note that you will have to rebind the scorecard everytime you make a change in the excel format!

Thanks,

Bala

[Former Member]

You should apply the required format in spreadsheet excel first then map it to scorecard component

[Former Member]

Hi,

You can use $ or percentage values in scorecard but you will not able to use as a scorecard it will be just a chart

Regards,

Ganesh