Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Not sure but you can try something like that :
sum({$<ORDER={"$(=max({<I_CANT_TRANSMITIDOS={">0"}>} ORDER))"}>} I_CANT_TRANSMITIDOS)
Hi,
Try this expression, it should be works :
sum({$<ORDER={"$(=max(ORDER))"},I_CANT_TRANSMITIDOS={">0"}>} I_CANT_TRANSMITIDOS)
Hope that helps you
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...
Hi,
Not sure but you can try something like that :
sum({$<ORDER={"$(=max({<I_CANT_TRANSMITIDOS={">0"}>} ORDER))"}>} I_CANT_TRANSMITIDOS)