Skip to main content

Hi all, I am using the COUNT function to get the total number of invoices, PO, and line items that fulfill the conditions in the code statements. The problem is the KPIs I am using were created using COUNT functions, which makes it impossible to get the total numbers by nesting the entire code in another COUNT function. This gives the error message:  Aggregate expressions cannot be nested inside aggregate expressions. 

Does anyone have an idea how I can resolve this issue? The code is added also.

 

Be the first to reply!

Reply