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

slittletke
slittletke
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 slittletke
Customize the badges you want to showcase on your profile
Re: trouble calculating empty fields - Adobe LiveCycle 06-05-2011
Also, you don't need to use Sum(), it's for summing a range of values. And I'm not sure what's going on with the square brackets you're using - that looks really odd, the square brackets are used to denote instances of fields.So your script should look more like:$ = (PD1*DN/DV[WD1*CT])/BPYExcept, as I said above, I'm not sure what the value in the square brackets is doing.Other than that you'll need to do as George said you'll need to script for the null values in the fields that are empty to st...

Views

219

Likes

0

Replies

0