Why is this calculated column not calculating the output properly?

[Anonymous]

I created a calculated column with this DAX code and got the below output: 

CL OOL = 
SWITCH (
    TRUE (),
    AND (
        IFERROR ( INT ( Panel_1[Value] ), "Not Running" ) >= Panel_1[Min],
        IFERROR ( INT ( Panel_1[Value] ), "Not Running" ) <= Panel_1[Max]
    )
        || Panel_1[Index] IN { 91, 92, 93, 94, 95, 96, 97, 98 }, "In Limits",
    IFERROR ( INT ( Panel_1[Value] ), "Not Running" ) = "Not Running", "Not Running",
    "OOL"
)

The CL OOL column should show In limits if the Value column is between min/max and OOL if it is outside the min/max range. If the Value is "NA" then it should output Not Running. Some of the indexes, e.g. 91/92/93 should always display In Limits. In the picture below, 0.979 is clearly between 0.90 and 1.03 so why is it OOL?

[johnt75]

The INT function rounds a number down to the nearest integer, which for 0.979 is 0.

I'd suggest changing the column types for min, max and value to be a decimal number and use BLANK() to indicate that it is not running.

[Anonymous]

Hi @johnt75, The data type for min/max is already decimal. The value column has type text as some of the rows have "NA" as an output. Is there a way I can stop it rounding down to the nearest integer?Should I replace the INT function with something else. Cheers

[johnt75 · Accepted solution]

Replace INT with VALUE, that will try and convert it to a decimal number