cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Values only in M (Million) Format

Nazeer
8 - Cloud Apps
8 - Cloud Apps

Hi Team,

we are trying to format my currency value only with M (Million) format.

Sisense gives a full number when the value is less than 1 M.

Is there any way we can bring the values to 0.01 M.

Nazeer_0-1650537359569.png

Thanks,

Nazeer

1 REPLY 1

harikm007
13 - Data Warehouse
13 - Data Warehouse

@Nazeer ,

Please try this script : 

widget.on('processresult', function(se, ev){
	ev.result.plotOptions.series.dataLabels.formatter = function () {
		return (this.y/1000000).toFixed(2) + 'M'		
	}
})

harikm007_0-1650566987792.png

-Hari