Need a Scaling Factor column added either to a Characteristic or KF structure in BEx Query Designer

[Chris_Pittman]

In BEx QD, is there a way to either add a free text field into the characteristic structure or maybe add a key figure that contains partial text? Our customer wants to have the scaling factor labels spelled out next to the goal amounts. As show below and attached. If not spelled out, they might settle for M/B next to the numbers. The scaling factor feature (at least in this version of the QD) seems to want to put it in the KF header as 1000000s or 1000000000s. We are on the 7.4 release of QD Revision 739. Any information about why this can or cannot be accomplished would be very helpful. Also, if you know it is possible in later versions of BW that might help as well. Also, we would like to do this without modifying the info providers if possible.

Thank you!

Chris

	1st Choice Solution*	2nd Choice Solution**
Area****	Goal	Goal	Goals (hidden col.)	Actuals	% Actuals to Goal
Discretionary Support	$123 Million	$123M	123,000,000	$12,354,600	10%
Future Needs	$321 Million	$321M	321,000,000	$32,154,600	10%
Operational Support	$1 Billion	$1B	1,000,000,000	$225,460,000	23%
Research	$2 Billion	$2B	2,000,000,000	$825,460,000	41%
Building	$200 Million	$200 M	200,000,000	$20,254,600	10%
Total	$3.64 Billion	$3.64B	3,644,000,000	$1,115,683,800	31%
*      We would like to have different scaling factors possible for rows with the "Millions" and "Billions" labels spelled out. This could either be the separate scaling of a key figure column or, if possible, the insertion of a text field that cooresponds with the row characteristic nodes.
**     Same as the 1st choice but have "M" and "B" as the scaling indicators instead of being spelled out.
***   Goals (In case the goal is a text column this would be used for the % calculation but would be hidden)
**** This is a characteristic structure comprised of multiple characteristic selections along with formulas.