Focal Point
Displaying negative number data in bar graphs

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

June 20, 2008, 10:58 AM
fex08
Displaying negative number data in bar graphs
I am showing negative number data on my horizontal bar graph and our standards are to display negative numbers with brackets instead of (-) minus signs. My data is formatted as D5B but the graph defaults to the minus sign.
June 20, 2008, 11:31 AM
mgrackin
Using DataTextFormatPattern should do it for you. However, I cannot find a good example that demonstrates how to use it. Check with IB for assistance.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
June 20, 2008, 11:31 AM
fex08
The following commands seem to manipulate the formatting of my data on the bars but I still do not know how to force the negative sign to be a bracket.
setDisplay(getDataText(),true);
setDataTextFormat(-1);
setDataTextFormatPattern("##");
June 20, 2008, 11:39 AM
mgrackin
I'm taking a wild guess here but try changing the pattern to "##;[##]". I honestly have no idea if this will work.

setDataTextFormatPattern("##;[##]");


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
June 20, 2008, 12:26 PM
fex08
Worked perfectly. Thank You!