For each Billing Date, I am attempting to count the number of Communications received on that same date even though not all Communications received belong to a document Billed on that date. The issue I am encountering is that only those Communications received on the Billing date are included in the numerator of the ratio. The billing document serves as my case key.
Page 1 / 1
Haven't tested it, but I'd try with PU_COUNT(DOMAIN_TABLE(<date column),<some column to count>)
HTH
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.