Formula Structure Problem

[Headache1000]

Using Business Objects 6.1 place the following 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 a date range previously entered by prompts when data is refreshed.

= 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")

I’ve look in the help section of the programme and that seamed a bit basic so any help would be greatly appreciated. Cheers

 

[blom0344]

Your expression is too complex and the between part is build with the wrong syntax.

You will probably find that it is easier to use 2 or even more steps (assign expression to variables)



Ties Blom