Expand my Community achievements bar.

Format Field with formula to not show negative numbers

Avatar

Level 1

Hello,

I am very new to adobe livecycle designer (es3), and even newer to calculate scripting. I created a formula in form calc language (see below) in a form, and it works as it's supposed to. However, the when no data is entered in the oct[0] field, it automatically calculates in the calculate scripted field and shows a negative number. I do not want to confuse the users of this form. Is there any way for me to format the calculate scripted field, so that it only shows 0 or nothing (preferably) when there is no data entered. Any help you can provide would be greatly appreciated.

Formula:

if(oct[0]>250)then

120

else

oct[0]-130

endif

0 Replies