circular dependency - need help on formula

Hi P0ach3r1 

Can we maybe first try to simplify the formulas? I do not see the tables but I think the formula could also be written like this.

I assume that you crete the calcualted column in the same table where you also store all the columns you refer to, right?

Please build first this column

Abs_Variance =
ABS (
    IFERROR (
        DIVIDE (
           [Actual/Projected] - [Client Forecast],
           [Actual/Projected]
        ),
        0
    )
)

and then this

RAG =
IF (
    [Abs_Variance] < 0.05,
    "Green",
    IF (
        [Abs_Variance] < 0.01,
        "Amber",
        "Red"
    )
)

Please tell me what happens.

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.