Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!
SOLVED

## sum help. Multiply cell b + c + d * 200000 / a

Level 3

This formula is driving me crazy. Its a 3 step process. For one cell.

I need to add cell  b + c + d

Then take that number and times by 200,000

then take that number and divide by a

Does anyone have an idea?

1 Accepted Solution

Level 5

Hi,

Following radzmar instruction above to change the code to be

Can you try that document and see if it works for you, this works for me, when

a != 0

b,c,d,e can be 0

Hope this helps

Malcolm

30 Replies

Level 3

I get zeros in TIR and LTA fields..

Im using Livecyle and testing in acrobat..

Level 5

It doesn't work for me because I have the console set up to show when an exception is thrown and break so no more code runs, if I switch that off it is works without any visible problems, just as I noticed it I thought I should mention it.

Regards

Malcolm

Level 3

Barlae are you able to see a total other than 0 in the TIR and LTA fields?? I cant, it worked yesterday and now i get 0s

Level 10

Ahhh ok,

I thought all values have to be greater than 0.

If not, change the script into:

Level 5

Hi,

This is what I get.

Which looks roughly like what I expect to see.

Regards

Malcolm

Level 3

Thank Your so very much for attempting to help me fix this mess

Level 3

Crap, the calculations are still not working on my end for the TIR or LTA fields.

fields a - e are whole number 0 - 1000000

field f is b - e added up

TIR is field f x 200,000 / field a

LTS is field b - d added up, x 200,000 / field a

-----------------------------------------------------------------

Field A will never be zero

Field B could be zero
Field C could be zero, but not likely
Field D could be zero, but not likely
Field E could be zero
Field F could be zero

Level 5

Hi,

Following radzmar instruction above to change the code to be

Can you try that document and see if it works for you, this works for me, when

a != 0

b,c,d,e can be 0

Hope this helps

Malcolm

Level 3

Malcom, I dont know what the difference between your form and mine was. Probably something small and silly.

But it works!! It works great.....

Thank you so much

Radzmar, Thank you so much for helping me get this mess fixed

Now one little last question and i will be one happy camper... Is there a way to only show 2 decimal places?

Level 3

Nevermind I figured that out too