Search results

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 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...