8 Replies Latest reply: Feb 6, 2013 3:47 AM by Giampiero Cina RSS

    Variable in Set Analysis for text replacement

    Raghu Dubey

      hello All,

       

      I have lot of expressions in my document which have similar pattern in the set analysis, although the measures differ.

       

      ='$'&NUM(ROUND(SUM({<name={'Baby Products'}>}sales)),'##,###,###,###')

       

      this and similar expressions where the 'Baby Products' changes as needed.

       

      Question 1: Is there a way I can put the whole expression in variable for reusability and pass the  'Baby Products' or other value as parameter?

       

       

       

       

      Question 2: I tried putting atleast the "name={'Baby Products'}" in a variable and called vSetFilter and use the expression '$'&NUM(ROUND(SUM({<$(=vSetFilter)>}sales)),'##,###,###,###') but it does not work.

       

      Thanks

      Raghu