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

Learn more

View all

Sign in to view all badges

Dwight_Friesen
Dwight_Friesen
Offline

Badges

Badges
2

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
3

Discussions

Discussions
0

Questions

Questions
3

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Dwight_Friesen
Customize the badges you want to showcase on your profile
Re: if / then calculation based on dropdown list value in repeating row - Adobe LiveCycle 04-04-2011
Or do I / can I nest an if/then statement within a sum calculation? If so, how?Cheers,df

Views

76

Likes

0

Replies

0
Re: if / then calculation based on dropdown list value in repeating row - Adobe LiveCycle 04-04-2011
NumericField3 is the name of the field containing the product of NumericField1 * NumericField2. I have created a NumericField8 in the form with the following calculation in FormCalc:if(Table1.Row.DropDownList1.rawValue == "ADVERTISING") thensum(Table1.Row[*].NumericField3)end ifThat's not helping. I think I need to designate variables before the if/then script, yes? Would I need to use a resolve command, a getfield command, or . . .? Can anyone help?Thanks, in advance,df

Views

75

Likes

0

Replies

0
if / then calculation based on dropdown list value in repeating row - Adobe LiveCycle 04-04-2011
HelloI am new to Livecycle. I have created a repeating row in a form. The last field in the repeating row is a numeric field that = the product of two previous fields in the row (NumericField1 * Numeric Field2). I also have a DropDownList1 near the beginning of the row (third column) that contains variable categories for that calculation row, e.g. Advertising, Office Supplies, Entertainment. I would like to create numeric fields in the form (perhaps in a footer row?) that contain sums of the sub...

Views

827

Likes

0

Replies

2