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
Mission!

Learn More

View all

Sign in to view all badges

# Adobe LiveCycle (Archived)

## Convert an excel formula into javscript for livecycle

boden75
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
View profile

boden75
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
View profile
boden75
Level 1

02-08-2016

Wondering if someone can help me out by making this functional in Livecycle. Thank You

If (DecimalField2 < 1, DecimalField4, DecimalField8)

#### Accepted Solutions (1)

mattiaswallin
Level 2

Likes

11 likes

Total Posts

51 posts

Correct reply

8 solutions
Top badges earned
View profile

mattiaswallin
Level 2

Likes

11 likes

Total Posts

51 posts

Correct reply

8 solutions
Top badges earned
View profile
mattiaswallin
Level 2

03-08-2016

Okay then the code will be:

if (DecimalField4.rawValue < 1){

DecimalField25.rawValue = DecimalField2.rawValue

}

else {

DecimalField25.rawValue = DecimalField4.rawValue

}

And to make it more rigid use full paths to your fields, for example "form1.page1.DecimalField4.rawValue".

And this code should be entered on the calculate event for the DecimalField25 I would say. (could probably be used on an exit event of DecimalField4 aswell, seeing it seems like you do a lookup on that value).

Hope this has helped, if it works please mark my answer as correct.

Regards, Mattias

#### Answers (2)

boden75
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
View profile

boden75
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
View profile
boden75
Level 1

03-08-2016

I will try to explain a bit better what I'm trying to do.

In a decimal field(DecimalField25), I would like that field to look at another decimal field(DecimalField4). If the value in DecimalField4 is less than 1, then look at another decimal field(DecimalField2) and use the value that was entered into DecimalField2 and input it into DecimalField25. If the value in DecimalField4 is greater than 1, then simply use the value that was entered into DecimalField4 and input it into DecimalFeidl25.

Hope this explains things a bit better. Thank You

mattiaswallin
Level 2

Likes

11 likes

Total Posts

51 posts

Correct reply

8 solutions
Top badges earned
View profile

mattiaswallin
Level 2

Likes

11 likes

Total Posts

51 posts

Correct reply

8 solutions
Top badges earned
View profile
mattiaswallin
Level 2

02-08-2016

Okay, I am not perfectly skilled in excel, but from what I know of their if statements, that code would be written as =IF(DecimalField2 < 1, DecimalField4, DecimalField8). And that would mean "if decimalfield2 is less than one, enter decimalfield4 in the field in which this function is written, else enter decimalfield8."

Therefore it is a bit hard to understand what you want to achieve... It would have helped if you would have simply wrote two sentences of about what you want to achieve. However, doing my own interpretation that you want this in a decimalfield of it's own (which I will name DecimalField1) the code would look like:

if (DecimalField2.rawValue < 1){

DecimalField1.rawValue = DecimalField4.rawValue

}

else {

DecimalField1.rawValue = DecimalField8.rawValue

}

So, this is the real answer to your question, however I am afraid it is a bit lackluster, but then you need to ask better questions.

And I would also encourage you to learn the concepts of if statements, it is such a core method of any programming, scripting aswell. So if you are doing anything code related, you really should know how to search for if statement syntaxes and such.

Hope this was to some help.

Regards, Mattias