Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hola Javier,
Podrías subir un QVW de ejemplo?
Si, Claro, Aquí está.
Gracias!!
Hi,
Create the following expressions
Expression 1:
RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))
Now use this expression in another expression like this
([Expression 1 Name]>=0.80,'B',
(
[Expression 1 Name]>=.50,'A',
(
[Expression 1 Name] <=0.50,'AA')))),'AA')
Here we are instead of calculating the expression many times we are reusing the expression 1 in expression 2.
If you are using straight table then hide the first expression column in Presentation tab.
Regards,
Jagan.
Thank you Jagan but, It takes more time than the original expression. 😕
Hola Javier,
Ya le estuve echando un ojo y esta difícil optimizarlo para el acumulado y
comparación que haces. Lo único que se me ocurre es que acumules en el
script.
Sent from my iPad
On Feb 15, 2012, at 10:18 AM, javierortiz <