Formula for finding project status!!

[Former Member]

Hi all,

I need help for  formula to get the status of a project looking at  project_id and task status , if all the task_status of a particular project is done then the status should be Done for that particular project ID.

How to create a crystal formula?

the scenario is

Project_ID	Task_Name	Task_Status
10	abc	Inprogress
10	xyz	Done
10	lmn	Inprogress
20	qwe	Done
20	asd	Done
30	tyr	Inprogress
30	ghj	Done
30	ert	Done

[abhilash_kumar · Accepted solution]

Hi Ajith,

Here's what you need to do:

1) Insert a Group on Project ID. You may suppress the Group Header and Footer if you don't need them.

2) Create a formula (@Status) with this code:

If {Project_Status} = 'Done' then 1

3) Create another formula with this code and place this on the Details Section:

IF Maximum({@Status}, {ProjectID}) = 1 and Minimum({@Status}, {ProjectID}) = 1 then

     'Done'

else

     'In Progress'

-Abhilash

[former_member205840]

Hi Ajit,

Also you can create a group on Project ID  and create following formula in detail section:

If {Trask_Status} = 'InProgress' then 1 else 0

Now insert a summary on group footer :

If the group footer summary is grater than 0 then In progress else Done .  The formula would be :

Sum({@fromula},{Project_ID}) > 0 Then 'In Progerss' Else 'Done'

Thanks,

Sastry