Select function with between value

[Pedro_Paulo_San]

Hello! I have a table with the fields below. I need to enter a salary value in the app and, through a SELECT ( ) function, search for the PER_ALIQUOTA field in which the salary is between the MINIMUM_VAL and MAXIMUMVAL_VAL fields.

I'm using the formula below, but it doesn't return the desired value:

SELECT(TBRL_BASE_CALCULO_INSS[PER_ALIQUOTA], AND([_THIS].[VAL_SALARIO_BRUTO]>=[VAL_MINIMO], [_THIS].[VAL_SALARIO_BRUTO]<=[VAL_MAXIMO]))