[SOLVED] Format Fact Row Item

[bozobozo]

Hello-
I have a very simple crosstab where I wish to show the unit cost of a part number in the side row area.  The unit cost is a fact.  The unit cost will display properly such as 2193.19 but I wish to be able to format it as currency, decimal pts etc like $2,193.  However, I only seem to be able to format this as a Text option in RS.  I've played with many properties in both FM and RS to no avail.  Again, this is a fact used in the row area that I wish to format.  THANK YOU!

[HalfBloodPrince]

select crosstab intersection, then got to ansistor button and select crosstab fact cell and then set the desired format.

[bozobozo]

In FM - I set the Cost as an Attribute (even though it is a number) along with my desired formatting of currency, decimal pts, etc.  (On a side note, I guess it does make some sense to have this as an attribute since it is a descriptive piece of info of our part number much like Description or Commodity.)

Then in RS, I select the item (which is a crosstab node member) and change the Source Type property from Member Caption (the default) to Data Item Value...and voila, RS happily displays the desired formatting of Cost (that I defined in FM) with Cost sitting in the side rows area.

"What you seek you shall find in properties, grasshopper"  bowing honorably.

[bozobozo]

Hi..I have provided the solution below.  But, can someone tell me how I designate an item as "SOLVED".  I see people doing that in other posts.  Sorry for being dumb.  Thank you.