4 Replies Latest reply: Aug 14, 2013 2:52 PM by Shannon Spangler RSS

    Best Way to Setup This Code

      Hi,

       

      I have some code that I'm using in one of my expressions in a straight table, and it works.  In one of the dimensions I am going to have to compare the value returned by the code from the expression below, to the quartile threshholds in another table to determine which quartile the value falls into.  There are 4 quartiles, so I am going to need to reference the value 4 times in the conditional statement in my dimension. I could paste this code into the conditional statement each time I am referencing the value, but that is going to make for one huge conditional statement, so I'd like to to find a cleaner way to do this.

       

      As far as I can tell, it will not allow me to call the expression in the dimension. I tried pasting this code into a variable and calling it from my straight table , but ever single row of the straight table ended up with the same value in the field (which was the aggregated total for all of the records combined).  It did not consider only the individual profit center's values. Is there a way to get the variable to treat each row of the straight table separately?  Or is there another way besides a variable that would work better?

       

      Thanks!

      Code.jpg