I was hoping I could pick your brain about modifying a Generic Inquiry where the results can be grouped together based on a specific string or text pattern. For example, values such as “COMPANY1”, “COMPANY2”, and “COMPANYABC” would be grouped under “COMPANY,” while “SELLERA” and “SELLERB” would be grouped under “SELLER.”
I was hoping to manipulate it in the Group By tab but was getting an error: Operand data type datetime is invalid for sum operator.
+4
This can’t be summed so it needs to be removed or have the aggregate function turned off, as it works when this field is not included in the GI results
This can’t be summed so it needs to be removed or have the aggregate function turned off, as it works when this field is not included in the GI results
You’re right. I tried removing this and for the inquiry to work. Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
