2 Replies Latest reply: Apr 18, 2011 7:30 AM by Erich Shiino RSS

    Error in calculated dimension

      Hi,

      I've tried to introduce a calculated dimension in a chart and it gives me an error in the expression, could somenoe chek it and tell me where the problem is??

       

      =IF(SITUACIÓN <> 'P3','OBSOLETO',

      IF((sum({<[Luogo di spedizione]={'6a01'}>}Venta)/[Qtà stk. val.])>=1,'BUENA ROTACIÓN EN P3','MALA ROTACIÓN EN P3'))

       

       

       

      Thanks for your time!!!

       

       

        • Error in calculated dimension
          Nathan Furbank

          Do you need double quotes around the set analysis part? Just a guess from looking:

          sum({<[Luogo di spedizione]={"6a01"}>}Venta)

          • Error in calculated dimension
            Erich Shiino

            Try

            =IF(SITUACIÓN <> 'P3','OBSOLETO',

            IF((sum({<[Luogo di spedizione]={'6a01'}>}Venta)/sum([Qtà stk. val.]))>=1,'BUENA ROTACIÓN EN P3','MALA ROTACIÓN EN P3'))

            but I think you will need a Aggr expression to make it work as you need.


            Where would you apply the SITUACIÓN FIELD?

            Let us say that it if for Regions

            then your expression could be:


            =aggr( IF(SITUACIÓN <> 'P3','OBSOLETO',

            IF((sum({<[Luogo di spedizione]={'6a01'}>}Venta)/sum([Qtà stk. val.]))>=1,'BUENA ROTACIÓN EN P3','MALA ROTACIÓN EN P3')), REGION)