0 Replies Latest reply: Jan 19, 2015 4:09 PM by Rick Guntang RSS

    dynamic expression

      I have a table that has aggregated fields but broken out by channel flattened out

      ResponseoResponsesResponse
      532
      10100

       

      Example:

       

      Response = total response

      OResponse = online response

      SResponse = store response

       

      I have variables that represent Online, Store and All in an inline table that is subsequently loaded into a list box. I then have a variable, vChnl, that transforms the selection into 'o','s' or null respectfully.

       

      Instead of listing all of the aggregate items, I want to select a channel from a list box where it will concatenate 'vChnl' & Response to dynamically create my aggregate for All Response, Online Response or Store Response.

       

      In a text box, i can create the text i.e. oResponse, sResponse, Response,  but I cant get it to replace it as an aggregate.

       

      Text Box =  vChnl & 'Response'

       

      Goal

      1. Have user select Store, Online or All

      2. Have the aggregate transform from " Sum ( Response ) " to " Sum ( oResponse ) " based on the use selection.