3 Replies Latest reply: May 15, 2012 1:47 PM by Tim Benoit RSS

    How to evaluate a variable to a field in an expression

    James Shenton

      I'm sure there's a straightforward answer to this, but I can't find it I'm afraid.


      I want to include a variable field in a chart expression.


      e.g. suppose the expression is sum( {$<Product = {}>} Sales). It's the Product bit that I want to vary.


      So what I want to do is something like sum( {$<field(vVariable) = {}>} Sales), so that by changing vVariable, the expression uses a different field.


      I can't seem to evaluate the variable to become an actual reference to a field, if you see what I mean. Can this be done?


      Thanks as always