I have a field that is a calculated field. Currently my formula (formCalc) for the field "Need" is just $ = Budget - EFC. This works fine until the EFC field is higher than the Budget, in which case I get a negative number. I would like for "Need" to be zero if the calculation results in a negative number. I am pretty new at this. Can anyone help me?
Thank you
Michelle
Views
Replies
Total Likes
how about something like this?
if(need.rawValue<0)then
need.value="0"
endif
Views
Replies
Total Likes
Do I leave the original formula as well?
Michelle Smith
Financial Aid Advisor
Western Texas College
6200 College Ave
Snyder, TX 79549
325-574-6598 (phone)
866-270-6184 (fax)
msmith@wtc.edu
Views
Replies
Total Likes
Do I need to keep the original formula as well?
Views
Replies
Total Likes
Try this:
if (Budget - EFC < 0) then
Need = 0
else
Need = Budget - EFC
endif
Views
Replies
Total Likes
I get a script failed:
Error: accessor 'Need' is unknown.
Views
Replies
Total Likes
Sorry, I figured out the problem. Thank you! The formula worked just great! I appreciate your help.
Views
Replies
Total Likes
It is formCalc and be sure the field names match the script names. (no "" around Need)
Views
Replies
Total Likes