Hello,
I’m looking for a way to count the color with the Generic Inquery, for example here, I want to count all the green case per line. Line 1 : 2 , Line 2 : 3 …
This is the query for the green and orange color :
I try a COUNT() but it didn’t work.
Do you have an idea ?
Best answer by sweta68
Hi
In your Generic Inquiry, create a new formula field that will be used to determine whether the color matches the criteria (e.g., green). The formula should evaluate to 1 if the color matches and 0 otherwise.
IIf([ColorField] = 'Green', 1, 0)Group the inquiry results by the fields that uniquely identify each line (e.g., Line ID).
Utilize the SUM() function on the formula field within each group. This aggregates the formula field values, effectively counting the occurrences of the color per line.
Regards,
Sweta
+15I dont imagine you can count the colours you should be able to use a similair IIF statement in the Data field on that line and set the value to 1 or 0 and then Sum these to work out how many greens etc.
+4Hi
Otherwise it could be that this intention is better executed in a report via Report Designer.
Hi
In your Generic Inquiry, create a new formula field that will be used to determine whether the color matches the criteria (e.g., green). The formula should evaluate to 1 if the color matches and 0 otherwise.
IIf([ColorField] = 'Green', 1, 0)Group the inquiry results by the fields that uniquely identify each line (e.g., Line ID).
Utilize the SUM() function on the formula field within each group. This aggregates the formula field values, effectively counting the occurrences of the color per line.
Regards,
Sweta
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
