1 Reply Latest reply: Oct 25, 2012 7:13 AM by Liron Baram RSS

    Populate the expression labels based formula

    Anurag Bharat

      Hi,

       

      I am developing a report where i need to populate the expression labels based formula. Here is the details.

       

      In the chart the expressions are coming from one table, where the names are based on the table from where they come. E.g. MRSH03 is the table name so the field name is MRSH03_EXPOSURE.

      1.png

      But in my report the field names I cant show, and some times the names can varry also. Llike it may be a month. So I have created another table, where I have kept the expression names and the represented name in the report.

      2.png

      Is there any formula so that I can get the expression column name, so that I can map the represented name.

       

      For example, formula in the below highlited field so that the output will be MRSH03_EXPOSURE.

      3.png