3 Replies Latest reply: Mar 16, 2012 11:22 AM by Juan Vitantonio RSS

    How to use a dimension of a straight table as a parameter of an expression



      I'm using a variable with parameters and I want that one of the parameter be the dimension of a straight table. So that the calculation is made depending on the value of the dimension. Each value of the dimension corresponds to a different field in my facts table. It's OK if I choose only one value in my dimension, but if I choose no values are several values, it doesn't work anymore.


      My variable is :


      Sum({1 <View = {"$2"},$CalendarId={"$3"}>} [$1])


      The dimension in the straight table is called PnlDim, and I call it through the parameter $1 in my expression :



      Any idea ?