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