5 Replies Latest reply: Oct 24, 2014 4:55 AM by Martin Pohl RSS

    Variable as a Dimension ( or Variable Dimension)

      Hi!

      I'm struggling trying to know why this happens:

      Dimension (Option A): =if(SupContrato > 26000 , SupContrato, null())

      Dimension (Option B): =if(SupContrato > $(Rango4), SupContrato, null())

       

      Option A works perfectly: it lists only the contracts which have a surface higher than 26.000sqm

      Option B: I change the 26000 for a variable that I declare within the script:

      Set Rango4 = 4*(max(SupContrato)/5); but it does not work because it gets null for everything.


      Many thanks for any help