title: Cognos frame work manager: format numeric column to show currency dynamically
body: <p>In this url, it is shown how you can format a particular column to according to particular currency. 
  <a href="http://publib.boulder.ibm.com/infocenter/caapps/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm_id13919format_SAP_query_items.html" rel="nofollow">http://publib.boulder.ibm.com/infocenter/caapps/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm_id13919format_SAP_query_items.html</a>  </p>
  
  <p>Now in a result set, there may be 2 rows and each may be of a different currency and also different number of decimals. According to the method here, it seems that we need to hard code the currency and the number of decimals on the entire column. Is there a way to set it dynamically?  </p>
  
  <p>I have two columns in the result set, one is the amount the other one is the currency. Based on currency, i want to format  the amount column. From db, the amount column just comes back as a number.
  How can I do it?</p>