0 Replies Latest reply: Jul 24, 2013 7:13 AM by Nevin Kumar RSS

    PLZ HELP - COUNT on IF condition on a CHART

      Hi..

       

      I want to identify NEW COPPER count based on the condition  when CONNECT DATE  >= RFS_DATE + 10 and ENTITY_TYPE = 'Copper' . The NEW COPPER count is mapped to chart.

       

      written code:

       

      COUNT (IF ((( Date(Date(Date#(REGION.RFS_DATE, 'MM-DD-YYYY'), 'MM-DD-YYYY') + 10, 'MM-DD-YYYY')) <= SERVICE_TRACKING.CONNECT_DATE

      AND SERVICE_TRACKING.ENTITY_TYPE = 'Copper', (SERVICE_TRACKING.ENTITY_TYPE)))
                         

      I have attached the report screenshot document for reference.

       

      I also identify TOTAL COPPER Count based on one more filter condition ie,

       

      IF (SERVICE_TRACKING.ENTITY_TYPE = 'Copper', (SERVICE_TRACKING.ENTITY_TYPE)). The TOTAL COPPER count is mapped to chart.

       

      The problem here is, When i click on the NEW COPPER option in a list box it would populate NEW COPPER and TOTAL COPPER count. Here the count should be SAME for both NEW AND TOTAL COPPER. I am not getting the desired result. In the atached screen NEW COPPER is 8 AND TOTAL COPPER is 7.

       

      Both the value should be 7, not sure where the issue is. 

       

      PLEASE HELP.