Hi,
I have a PivotGrid table with huge value. How do I customize the appearance of the value in the table using my sample javascript below?
function
FormatNumber(value) {
if
(value === 0) {
return
0 }
if
(value <= 999) {
return
value }
if
(value >= 1000 && value <= 999999) {
return
parseFloat(value / 1000).toFixed(1) +
'K'
}
if
(value >= 1000000 && value <= 999999999) {
return
parseFloat(value / 1000000).toFixed(1) +
'M'
}
if
(value >= 1000000000 && value <= 999999999999) {
return
parseFloat(value / 1000000000).toFixed(1) +
'B'
}
if
(value >= 1000000000000 && value <= 999999999999999) {
return
parseFloat(value / 1000000000000).toFixed(1) +
'T'
}
if
(value >= 1000000000000000 && value <= 999999999999999999) {
return
parseFloat(value / 1000000000000000).toFixed(1) +
'Q
}
return
value
}
Thanks.