2 Replies Latest reply: Nov 30, 2017 2:46 PM by Eduardo DImperio RSS

    Set Analysis Problem

    Eduardo DImperio

      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

       

      set_analysis2.JPG

      But my result with set analysis is zero

       

      set_analysis.JPG

      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)))