Modifier based on another field

[#1]

Hello;

I need to modify a field based on another field, in order to find the right number to compare with.

It works with a constant number (marked in red) but it does not work with the field, which is [Nuevo nivel resp.] (and at the same time is the Dimension).

IF([Fijo revisado] <

            Only(TOTAL

            {<[Número nivel]=

            {

            3

            }

            >}

            Mínimo),

        RGB(0,255,0)

What canI write instead of "3". I have tried:

[Nuevo nivel resp.]

and

$(=[Nuevo nivel resp.])

Thanks.

[Chanty4u]

hi,

IF([Fijo revisado] <     Only(TOTAL  {<[Número nivel]=   " {   3    }"   >}   Mínimo),

        RGB(0,255,0)

[HirisH_V7]

Hi,

Pls check in your Data,

Is there any Space Before or After the Value  3  .

[sunny_talwar]

Would you be able to share some data to understand how you data looks?

[#5]

Hi all:

Instead of using a modifier based on another field I have decided to load two tables from the same Excel sheet. With this solution I can avoid complex programming.