Recent content by Danielle

My report is sorted and grouped at 4 levels. One of the footer levels is "resource type". There are two resource types that get displayed- contractor and employee. The report displays different total lines each for contractor and employee. My problem is that I need to grab just the...

I just figured it out and it works. I had to add another set of parenthesis to the last calculation: ([Sum of ACTUAL HRS]-[Sum of GA07 OTHER NON PAID]). So, it looks like this: =IIf([RESOURCE TYPE]="EMPLOYEE",([Sum Of BILLABLE HRS]/[Sum Of EXP HRS ALL]),([Sum Of BILLABLE HRS]/([Sum of ACTUAL...

Thanks! I tried that and the formula works if the Resource Type = Employee, but it didn't work if the Resource type was not employee. It gave a 0%. I don't know why. Do I need to add another IIf?

This is what I have so far in the control source for the control, but the syntax is wrong: =IIf[RESOURCE TYPE]="EMPLOYEE",[Sum Of BILLABLE HRS]/[Sum Of EXP HRS ALL],[Sum Of BILLABLE HRS]/[Sum of ACTUAL HRS]-[Sum Of GA07 OTHER NON PAID] There are only 2 Resource Types-EMPLOYEE and CONTRACTOR...

I have the following in an expression in a control on a report, but the syntax is wrong. =IIf[RESOURCE TYPE]="EMPLOYEE",[Sum Of BILLABLE HRS]/[Sum Of EXP HRS ALL],[Sum Of BILLABLE HRS]/[Sum of ACTUAL HRS]-[Sum of GA07 OTHER NON PAID] Can you please tell me what is wrong? This expression...

Hi, I need a module that will probably need to use an if/then stmt, but I am not sure how to use it. I have a formula that does a calculation for my report, but I need it to perform different calculations based on a field. I need it to say: if [Employee Type] = "Contractor" then [Sum Of...