In saved search, Formula(numeric) is not working as expected.

ROUND({trandate} - {today}, 0)

, here trandate is 1/22/2024 6 days away as today is 1/16/2024 but this ROUND({trandate} - {today},0) returns 5. Is there any mistake?

see what

{trandate} - {today}

is. You may be wanting the behaviour of the

CEILING

function