0 Replies Latest reply: Apr 7, 2015 3:14 PM by Leslie Blumenfeld RSS

    Problem passing formulas to an expression in a pivot table

    Leslie Blumenfeld

      I'm having a problem passing formulas to an expression in a pivot table. The project I'm working on is confidential and I'm not allowed to show any part of it, so I've created a very simple example... Please bear with me.

       

       

      In my script, I define this...

      SET f_Something = '$1';

       

      If I use the following as the expression in a pivot table

       

           $(f_Something('HI'))

       

      then it works and I get     HI

       

      There are several formulas that I will possible need to use in the expression, so I've loaded them from a table. I can already correctly select the correct formula to replace in the expression, but when I do this, it doesn't work (I get null).

       

      For example, suppose F will contain the formula I'd like to replace and it currently equals f_Something('HI')

      then if I use the following as the expression:

       

           =F

       

      I'll see f_Something('HI'), which is exactly what I'd expect to see.

       

      Now, I want to execute that function. I've tried:

      $(F)

      $(=F)

      =$(F)

       

      But all return null. How do I get the dollar expansion to execute my function and give me the correct result, which is

       

      HI

       

      Thanks!