4 Replies Latest reply on Sep 16, 2016 6:28 AM by Steven Carter

    LOD Calculations

    André Coelho

      Hello everyone!

       

      I'm trying to sum how many times the dimension called [Nome] is classified as: "Em Falta", "Excedido" or "OK!".

       

      I want to see in my viz only the dimension [Name] and AGG(Cores Realizado x Previsto). For example:

       

                                            [Cores Realizado x Previsto]

      [Name]               |      Em Falta  |   Excedido    |       OK!

      Farelo de Soja    |    x records    |  y records      |   z records

                ....              |         ...          |        ...            |     ...

       

      The struggle here is that when I drop the dimension [Lot Fab] from viz I lost detail. (Image 2)

       

      To be more clear, I attached two .jpeg here.

       

      Thanks.

       

      André.

       

      Image 1.jpgImage 2.jpg

        • 1. Re: LOD Calculations
          Steven Carter

          Hi Andre,

           

          What's the formula for Cores Realizado x Previsto?

           

          Instead of using Number of Records, you may want to create an IF...ELSE statement that has similar logic to Cores Realizado x Previsto, but instead of returning a string just returns "1". That should give you a count of each, and when you combine it with the string version Cores Realizado x Previsto, you should be able to see your breakout.

           

          Regards,

          Steven

          • 2. Re: LOD Calculations
            André Coelho

            The formula is:

             

            IF SUM([Realizado]) = SUM([Previsto]) THEN "OK!"

            ELSEIF SUM([Realizado]) > SUM([Previsto]) THEN "Excedido"

            ELSEIF SUM([Realizado]) < SUM([Previsto]) THEN "Em Falta"

            END

             

            I created an IF...ELSE statement like you said but it keeps returning the number 1, same as the first image I sent and when I drop the dimension [Lot Fab] the viz returns the same result you can see in Image 2, without "OK!" column.

            • 3. Re: LOD Calculations
              Steven Carter

              Sorry, my quotes might have thrown it off. Try just a 1, without "".

               

              If that doesn't work, can you share the workbook?

               

              Steven

              • 4. Re: LOD Calculations
                Steven Carter

                You may also need to do an LOD calc:

                 

                { FIXED [Nome] : SUM([Calculation We Created Above]) }