Count mismatch in table and text box

[Veerendra_Katikala]

Hi Experts 

I wrote a following query which shows 7 Material Codes but as per the data it should have 6 Material Codes as per the logic and other one ( 10065281 ) should not be part of the table

if((Sum(([GR/IR Spend(GC)]*Exchange))/Sum(Quantity))>
(Sum(StdPricePerPOUOM*Quantity)/Sum(Quantity)),
count(distinct [Integrated JnJ Material Code])) 

10065281 should be removed from the list

I would like to display count of material codes in the Text box as well. quick help much appreciated 

[Lisa_P]

In your screenshot, I can't see the IF

[marksouzacosta · Accepted solution]

To hide the zero records, you can uncheck this property in your chart.

Regarding the count, your If expression looks fine. Your screen shot does not look to match that expression. Can you please double check?

Regards,

Mark Costa

[Veerendra_Katikala]

Thanks all for your time the Issue got fixed i did some blackened calculation and it worked