We calculate some accounts in a rule. If the calculated value is negative, I want to make it zero. H

Hi,

We calculate some accounts in a rule. If the calculated value is negative, I want to make it zero. Can anyone recommend a way of doing it?

I have tried  =MAX(the calculation, 0) but the rule got validation error and could not proceed. Here is the error message:

Trace:

An error occurred in: "Avg T12 Revenue Rate" = M...

An error occurred while parsing the script.

Please check the script between the line:14 column: 5 and line:14 column: 26.

Found token '"Avg T12 Revenue Rate"'- expected tokens: <EOF>,<DIGIT>,<LETTER>,"/*STARTCOMPONENT:SCRIPT*/","/*ENDCOMPONENT*/","/*STARTCOMPONENT:FORMULA*/","/*STARTRULE*/","/*ENDRULE*/","/*STARTTEMPLATE*/","/*ENDTEMPLATE*/","\"File\"","\"