Elena Posted July 10, 2014 Report Share Posted July 10, 2014 I have the following in one of my calculated field. When verified it is saying everything is valid. But when embedded and ran, my page is saying "error in formula". Is there a better way to set up ranges in calculated field? Below is what I have: CASE WHEN [@calcfield:5]=4361 OR [@calcfield:5]>=4360 THEN 'Grade 8'WHEN [@calcfield:5]>=3516 OR [@calcfield:5]=<4360 THEN 'Grade 7'ELSE 'Not Applicable'END Quote Link to comment Share on other sites More sharing options...
0 Elena Posted July 10, 2014 Author Report Share Posted July 10, 2014 Never mind this question. I figured it out. I realized I only need to put the lower bound of the range, and did not have to repeat the calculated field. Quote Link to comment Share on other sites More sharing options...
0 ParkLoey Posted August 31, 2023 Report Share Posted August 31, 2023 Hi! Just wanted to drop Caspio's function reference article here as well for everyone's reference when creating calculations: https://howto.caspio.com/function-reference/ Quote Link to comment Share on other sites More sharing options...
Question
Elena
I have the following in one of my calculated field. When verified it is saying everything is valid.
But when embedded and ran, my page is saying "error in formula".
Is there a better way to set up ranges in calculated field?
Below is what I have:
CASE
WHEN [@calcfield:5]=4361 OR [@calcfield:5]>=4360 THEN 'Grade 8'
WHEN [@calcfield:5]>=3516 OR [@calcfield:5]=<4360 THEN 'Grade 7'
ELSE 'Not Applicable'
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.