June 7, 2012 at 3:05 pm
Hi,
I have a report with two tables on it.
Inside each of those two tables I have an expression that counts the number of Org units in my group. I then subtotal the number of clients for each org unit.
In one table the expression counts the number of active employees by group. The other tables expression counts the number of terminated employees. The expression syntax is :
=count(Fields!EE_ID.Value, "ULTIPRO_WSI")
Everything works on the report. But they now want ratios beside all my subtotals.
My problem is that I now need to average the number of active employees over the number of terminated employees - but I need to show each ratio for each org unit in the grouping.
I don't know how to create an expression that I can add to my tables that will show the active/term ratio for each member of my grouping - I need the values for each iteration..not sure how to get those to use in my expression.
Right now all I'm doing is counting. I really have to take the sub totaled value from each table for each org unit and divide for each org unit.
Sorry if this is wordy...having a little trouble explaining. Hope that makes sense.
June 7, 2012 at 4:18 pm
Maybe it will help to simplify my request..
What I need is to be able to take both expressions from each table and divide them...something like
count(Fields!EE_ID.Value, "ULTIPRO_WSI")/count(Fields!EE_ID.Value, "dataset2")
problem is whne I use the above it gives me the total for all the groupings..
I need the sub total ratio from each member in the group - not the total of all the groups
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply