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