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

# LOD Calculations

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:

[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é.

• ###### 1. Re: LOD Calculations

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

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

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

You may also need to do an LOD calc:

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