Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Format Field with formula to not show negative numbers

alexish11748984
Level 1
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