Set analysis problem

[sergio]

Hello to all:

I have a problem with set analysis again. I have the next expression on a pivot table:

sum({$<ORDER={"$(=max(ORDER))"}>} I_CANT_TRANSMITIDOS)

This expression gets the last value of I_CANT_TRANSMITIDOS, but i need to add a new condition, i need to get the last value if I_CANT_TRANSMITIDOS <> o. I tried:

sum({$<ORDER={"$(=if(I_CANT_TRANSMITIDOS<>0,max(ORDER)))"}>} I_CANT_TRANSMITIDOS)

and

sum({$<~I_CANT_TRANSMITIDOS={0},ORDER={"$(=max(ORDER))"}>} I_CANT_TRANSMITIDOS)

but it doesn't works, how can i add the condition to the set analysis.

Thanks to all in advance.

[martin59]

Hi,

Try this expression, it should be works :

sum({$<ORDER={"$(=max(ORDER))"},I_CANT_TRANSMITIDOS={">0"}>} I_CANT_TRANSMITIDOS)

Hope that helps you

[sergio]

Thanks Martin, but it doesn't work. It gave me the sum of I_CANT_TRANSMITIDOS for the max ORDER but not considered the I_CANT_TRANSMITIDOS > 0...

[martin59 · Accepted solution]

Hi,

Not sure but you can try something like that :

sum({$<ORDER={"$(=max({<I_CANT_TRANSMITIDOS={">0"}>} ORDER))"}>} I_CANT_TRANSMITIDOS)