Focal Point
[CLOSED] Data Label Format Rounding Issue

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1557051196

March 04, 2019, 03:54 PM
JulieA
[CLOSED] Data Label Format Rounding Issue
This seems simple, and I have read about customizing data label formats on the forum and in the documentation, but perhaps I am missing something.

Here is the snippet of code I'm working with:

setTextFormatPreset(getDataText(),-1);
setTextFormatPattern(getDataText(),"$#.#")

I'm using a custom format because I want to show my amounts that are in billions as $1.2B. The challenge is that I have several values a less than a billion. So, what AppStudio is currently doing to my graph is giving me $911.4M instead of $0.9B. Is there a way to add the decimal place? I've been reading about PresetNumberFormats. When I try to use preset value 10 or 11, I get $0B. That's definitely not what I need. Thoughts?

The graph fex is very small, so I want to keep the fix simple.

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus 8.2.04
WebFocus 8.2.04

March 05, 2019, 04:04 AM
Addy
There is no straight forward way of doing it.
you can check the following post
Data Label workaround


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006