Need help with a script

[jeanette614]

I am very inexperienced at scripting but I need a script to show a zero if a number goes negative.  So what I have is:

$.rawValue = X - Y

But I need rawValue to never show a negative number, only a zero when that value becomes a negative. Otherwise, show the value.

Please help.

[Srini_Dhulipall]

You can use the following script to display ZERO instead of negative numbers.

var FinalValue = X-Y;

if(FinalValue<0) then
$.rawValue = 0;
else
$.rawValue = FinalValue;
endif

Thanks

Srini

[jeanette614]

That seems like it should work but alas, it doesn't. Nothing shows in the field at all. Not even the negative numbers like I had before.

[Srini_Dhulipall]

Then the problem might be the language.. Set the scripting language to FormCalc instead of JavaScript in the Script editor. You can find it in the right had top corner in the Script editor.

Which event are you writing the code?

Thanks

Srini