"A formula cannot refer to itself" - Quandary

[LZido]

I have a formula that states if {@FLSA D11}is greater than the total of {@OtherOT} then minus {@OT D11}
and receiving an error - "A formula cannot refer to itself, either directly or indirectly"

Problem Formula

FLSA D11
if {@FLSA D12} <= 0
then Sum ({@ODC Hours D11}, {Coverage.PERSONNELLOOKUPID}) - [highlight #FCE94F]{@OT D11}[/highlight]
else Sum ({@ODC Hours D11}, {Coverage.PERSONNELLOOKUPID})

Referring Formula

[highlight #FCE94F]OT D11[/highlight]:
if {@OT D12} <= 0
and {@FLSA D11} > {@OtherOT}
then
{@OtherOT}

Tried to trick it with this formula.......

[highlight #8AE234]O D11:[/highlight]
if not(isnull({@OT D11}))
then
val(CStr({@OT D11}))
else
0

but it still gets an error about refers to itself.

Still a problem formula

FLSA D11
if {@FLSA D14} <= 0 and {@FLSA D13} <= 0 and {@FLSA D12} <= 0
then Sum ({@ODC Hours D11}, {Coverage.PERSONNELLOOKUPID}) - {@FLSA OT} - [highlight #8AE234]{@O D11}
[/highlight]else Sum ({@ODC Hours D11}, {Coverage.PERSONNELLOOKUPID})

I really need {@FLSA D11} to subtract from the value of {@OT D11}- any suggestions??

 

[kray4660]

You have circular reference, so I am not sure how you can fix it.