using >= in formula not showing as true for the equal

[Jodie]

I've been avoiding using greater than or equal in my calculation fields because I can't get it to return true when the value is equal. I'm trying to use the following CASE WHEN to display/hide blocks of html and fields when the condition is true, but it always hides the "=" field - so where I want the 10th item to display, it will only show the first 9 and hide the remaining. I've used work arounds in the past, but I really want to understand what I'm doing wrong.

This is the syntax I've used. Any ideas?

CASE 
WHEN [@field:PW_tbl_progitems_itemnum] >=10  THEN "block;"
ELSE "none;"
END

[Ilyrian]

Hi @Jodie

I tested your formula on my end, it worked fine.
Supposing your field is Integer this formula should work:
 

CASE 
WHEN [@field:PW_tbl_progitems_itemnum] >=10  THEN 'block;'
ELSE 'none;'
END

If your field is other than Integer then you could cast the value to integer:
 

CASE 
WHEN CAST([@field:PW_tbl_progitems_itemnum] AS int)  >=10  THEN 'block;'
ELSE 'none;'
END

The Output:

[Kronos]

Hi,

I would just like to add this to the thread regarding the use of function in a calculated value or formula field

Function Reference