Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Tooltip Abbreviation Currency
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Tooltip Abbreviation Currency
 Login/Join
 
Gold member
posted
I’m trying to format a tooltip into an abbreviated value, with a dollar sign, one decimal point and the abbreviation character.

For example:
1,778,000,000 should display as “Series For Label: $1.78B”
534,387,000 should display as “Series For Label: $534.4M”

Using some code I found on here by a couple geniuses, I was able to get this to work for billions, but my question is how can I make my code dynamic and work for Millions, or even in the rare event Thousands (K)?

Here is a snipit of the code I currently have that works for Billions:

  
*GRAPH_JS
series: [
{ "series": 'reset',
               tooltip: function(d,s,g){
                   var valueArr = this.data[0],total=0;
                                  for (var i=0 ;i<valueArr.length;i++){total+=valueArr[i].value;}
                           var sum= d / 1000000000  ;
               return this.getSeries(s).label + " For " + this.getGroupLabel(g) + ": " + "$" + sum.toFixed(1) + "B";
               }
  },
]
*END


This message has been edited. Last edited by: Joel Elscott,


WebFOCUS 8.2.03
z/OS
 
Posts: 66 | Registered: May 20, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
I solved my own issue. Below is the final code I used if anyone is interested. It's probably not the best way, but it works.

  
{ "series": 'reset',
	tooltip: function(d,s,g){
	    var valueArr = this.data[0],total=0;
		    for (var i=0 ;i<valueArr.length;i++){total+=valueArr[i].value;}
            if (d > 1000000000)
			{
				var sum= d / 1000000000  ;
				return this.getSeries(s).label + " For " + this.getGroupLabel(g) + ": " + "$" + sum.toFixed(1) + "B";
			}
			else if (d > 1000000)
			{
				var sum= d / 1000000  ;
				return this.getSeries(s).label + " For " + this.getGroupLabel(g) + ": " + "$" + sum.toFixed(1) + "M";
			}
			else if (d > 1000)
			{
				var sum= d / 1000  ;
				return this.getSeries(s).label + " For " + this.getGroupLabel(g) + ": " + "$" + sum.toFixed(1) + "K";
			}
 	}
},


WebFOCUS 8.2.03
z/OS
 
Posts: 66 | Registered: May 20, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Tooltip Abbreviation Currency

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.