changing the value of a formula field

[ABetha]

this is the formula I have

if {@DuplicateRep 2} = 1 and {@Hours } >0 then
{@Hours } = 0
else
{@Hours } = 1

This is the contents of {@DuplicateRep 2}
if {@DupSummary} = "dup" then
formula = 1
else
formula = 0
end if

THis is the contents of the {@Hours }
if val({vSerialNperation})>= 1 then
formula = 0
else
formula = 1
end if

if the record is a duplicate(equal to 1) I want to set the hours value to zero

 

[IanWaterman]

Just change {@hours} formula as a nested if

if {@DuplicateRep 2} = 1 then
(if val({vSerialNperation})>= 1 then
formula = 0
else
formula = 1)
else 0

Ian

 

[ABetha]

I get a message saying A summary has been specified on a non-recurring field Details: @Hours