Formula Structure Problem

[Headache1000]

Using Business Objects 6.1 place the folowing formula in a cell on table but fails: What i'm trying to do is display the number of jobs that match the count criteria between the date range.

= If <Date Job Completed (Status 3)> Between (<Period Start Date>,<Period End Date>) Then Count(<Job Number>) Where (<Work Centre Code>="QC45" And <Job Priority>="1") Else "0"

Period Start Date is a variable where formula:
=UserResponse(DataProvider(<Date Job Completed (Status 3)>) ,"Period Start Date")

and

Period End Date is a variable where formula:
=UserResponse(DataProvider(<Date Job Completed (Status 3)>) ,"Period End Date")

Now if I enter the actual dates instead of using the user reponces I can get the date section to work or if I just enter the Count function I can get that to work but not combined any help where i'm going wrong would be appreciated. Cheers

 

[BobSuruncle]

This shoul be posted in the "Business Objects solutions" forum.

http://www.tek-tips.com/threadminder.cfm?pid=393

Bob Suruncle