Question

calculations in a table

Forms Version 10 How To

Updated October 26, 2022

asked on October 25, 2022

Hello, I'm attempting (poorly) to do a calculation in the advanced tab. this relates to vehicle weight for heavy vehicles. this is what I need:

this is what I have:

where: Vehicle_weight is the table, DSActual_1 is the driver side actual weight, PSActual_1 is the Passenger side actual weight, (One of those will be heavier than the other) and Axle_Rating_1 is the total weight that it's divided by. Obviously the calculation above isn't correct and my math skills are poor (at best) then adding in index, row, function and parentheses has me totally lost. any help would be greatly appreciated. Thanks, Donnie

0 0

Answer

SELECTED ANSWER

replied on October 26, 2022

yep! I got help from someone in my organization with the ABS value and the decimals are on the Basic tab of the field. Thanks for all of your help!

0 0

Replies

replied on October 25, 2022

You can use as many new lines as you want, just press enter, it doesn't cause any problems with the functions. The problem with having a lot of ) characters is that it is unreadable without new lines. This is a lot more readable as multiply the difference between 2 values divided by a 3rd value from the row with the static number 100.

1 0

View 2 previous replies

replied on October 26, 2022

Chad, thanks for the help. So I get the following:

the -1.25 is the answer I was looking for. 2 questions, how do I make that a positive number and how do I get rid of the zeros so it's just 1.25?

0 0

replied on October 26, 2022

Chad, the original formula from Excel used ABS, but I'm not sure where that would go in this formula.

0 0

replied on October 26, 2022

Chad, I figured it out using ABS. thanks for the help!

0 0

replied on October 26, 2022

It might be the order of your subtracted values too. To set the number of decimals rounded up to in a field, check its settings as you edit the field. It should ask how many decimals you want.

0 0

SELECTED ANSWER

replied on October 26, 2022

yep! I got help from someone in my organization with the ABS value and the decimals are on the Basic tab of the field. Thanks for all of your help!

0 0

You are not allowed to follow up in this post.

Question

Question

calculations in a table

Answer

Replies

Sign in to reply to this post.