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
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
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
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.