Hello @tdr_Dinesh, just to confirm, is it the number of defects in a single category divided by the number of audits for that category or across all categories? I think you will likely want to switch the calculations to LAC-W aggregations to accomplish this. I’ll write the examples below:
GDR = distinctCountOver(ifelse(status=“No” AND (rating=2 OR rating=3), ordernumber, NULL), [{category}], PRE_AGG)
I am not certain how you are calculating the 171 currently, so update this next example with the proper fields:
Orders Audited = sumOver({Audited}, [], PRE_AGG)
If you want the orders audited by category, you can add the category field in the partition. Now that these 2 fields are utilizing the same aggregation type, you can divide them to get the percent.
Let me know if this helps!