How do I make a calculated field default to zero if the answer is negative

[Former Community Member]

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

[paulk07]

how about something like this?

if(need.rawValue<0)then

need.value="0"

endif

[Former Community Member]

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

[Former Community Member]

Do I need to keep the original formula as well? 

[paulk07]

Try this:

if (Budget - EFC < 0) then

    Need = 0

else

    Need = Budget - EFC

endif

[Former Community Member]

I get a script failed:

Error: accessor 'Need' is unknown.

[Former Community Member]

Sorry,  I figured out the problem.  Thank you!  The formula worked just great!  I appreciate your help.

[paulk07]

It is formCalc and be sure the field names match the script names.  (no "" around Need)