Sub-Summary sorted by Date -- in this part/section i also have following merge fields: total amount of units processed, the total amount of units passed, the total amount of units failed, and finally the accuracy rate.
Are these actually summary fields, or calculation fields based on summary fields? If not, then I suggest you look into the documentation to see how summary fields work, since …
i was trying to do a lookup function with the count function
You cannot use aggregate functions against a found set; that's what summary fields are there for.
alas, no bueno.
A real problem description would be far more helpful.
thank you for the quick reply, erolst. to answer your first question, these fields are calculation fields only (and not based on summary fields); and, yeah, i will look into summary fields. secondly, i was hoping that aggregate functions can be used in a found set. definitely wrong on my part there.
i quickly glanced at summary fields once before, however, didn't delve much into it, tho. will look at it more deeper and see how it goes with what i'm trying to do.
seems after thinking long and hard, and remembering what erolst have stated above, i have finally found the solution to this problem. again, thx erolst