Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi !
I need to do a complex (not complex but extense) set analysis, so i tried something more simple like this:
Sum({$<CONSUMO_TOTAL = {"> CONSUMO_MEDIA_TRIMESTRAL"}>}CONSUMO_TOTAL)
I have Value for CONSUMO_TOTAL and CONSUMO_MEDIA_TRIMESTRAL
But my result with set analysis is zero
why?
PS: The original expression that i want to transform to set analysis is:
SUM(If(CONSUMO_TOTAL>1.5*CONSUMO_MEDIA_TRIMESTRAL and CONSUMO_MEDIA_TRIMESTRAL>1 and CONSUMO_TOTAL>1 OR CONSUMO_TOTAL<0.5*CONSUMO_MEDIA_TRIMESTRAL and CONSUMO_MEDIA_TRIMESTRAL>1 and CONSUMO_TOTAL>1 ,(FABS(CONSUMO_TOTAL- CONSUMO_MEDIA_TRIMESTRAL))))
/
COUNT(If(CONSUMO_TOTAL>1.5*CONSUMO_MEDIA_TRIMESTRAL and CONSUMO_MEDIA_TRIMESTRAL>1 and CONSUMO_TOTAL>1 OR CONSUMO_TOTAL<0.5*CONSUMO_MEDIA_TRIMESTRAL and CONSUMO_MEDIA_TRIMESTRAL>1 and CONSUMO_TOTAL>1 ,(CONSUMO_TOTAL- CONSUMO_MEDIA_TRIMESTRAL)))
Hi,
Sample data set will be very helpful for someone to help you.
BR,
Vijay
Sorry VIJAY, can't give any sample about it.
Well i found a way to do it work
Sum({$<CONSUMO_TOTAL = {"=CONSUMO_TOTAL > CONSUMO_MEDIA_TRIMESTRAL"}>}CONSUMO_TOTAL)
but why is wrong the first example, don't know