1 Reply Latest reply: Jul 2, 2015 12:01 PM by Sunny Talwar RSS

    Calculating total in dimension

    Matt Maino

      I am attempting to use this calculation in my dimension but it is not working:

       

      if(sum(total <PROD_DT, REL_CD> VALUE) > 10000000, REL_CD))

       

      What I m trying to do is calculate a sum of 'VALUE' for each 'REL_CD' on a given 'PROD_DT' and only display that 'REL_CD' in the dimension if it's sum is greater than 10 million. Does anyone know why this is not working and if there is a way to successfully accomplish what I need?

       

      Thank you