I have an issue where I am trying to use the CountRows function with a Lookup function and I don't even know if this is possible. I am guessing by the error I am receiving it cannot be done but I thought I would ask the question anyway.
My report breaks down individual aspects of the staff members timesheet in non chargeable, chargeable, illness and so fourth which works fine however now I am trying to add a Bradford Factor column to assist our HR department.
Unfortunately it didnt work and came up with the following error "The Value expression for the textrun 'Textbox122.Paragraphs.TextRuns' contains an aggregate function in an argument to a Lookup or LookupSet function. Aggregate functions cannot
be used for the destination or result Expression parameter of a lookup function."