Calculating Completion of Task List

HCL Domino Domino Forum
1

Hi,

I have a computed number field with a default value of “0” called “Counter”. The formula below that is attached to the QuerySave event does not work.

@If(task1 !=“”;@SetField(Counter;“1”);“”);

@If(Counter=“1” & CompDate1 !=“”;@SetField(Counter;“0”);“”);

@If(Counter !=“1” & task2 !=“”;@SetField(Counter;“1”);“”);

@If(Counter= “1” & CompDate2 !=“”;@SetField(Counter;“0”);“”);

@If(Status = “4. Assigned” & Counter= “0”; Status = “5. Closed”;“”)

Can anyone provide insight to my error and the solution?

Thanking everyone in advance,

Linda

2

Subject: Calculating Completion of Task List

Your problem is probably your @SetField. eg. your code has @SetField(Counter;“1”) which means “set the value to “1” for the field which name is stored in the field named Counter”. If you want the field Counter to store the value change to @SetField(“Counter”; “1”);

3

Subject: RE: Calculating Completion of Task List

Thank you so much! :)))

I now have a functioning field.

Linda