You are viewing limited content. For full access, please sign in.

Question

Posted to Laserfiche Lounge

Question

Laserfiche Lounge

Formula for Laserficeh Form(s)

Forms Feature Quick Fields
Updated October 4, 2021
asked on September 29, 2021

Hi Everyone, 

I am trying to create a formula for a one of our forms. I am new to using the formulas and have some of them down but this one it stumping me.

I am trying to get a total amount to separate between two Budget/Accounting Codes based on the percentages. The employee enters in the Amount at the top and it goes directly to the Amt. in the Budget/Accounting Codes section but if they want to use two codes the amount needs to split based on the percentage they are indicating. 

It keeps adding the same total to both code lines but i want it to split based on the percentage box. Please help!

 

0 0

Replies

replied on October 4, 2021 • Show version history

Hi Nicki

To calculate the AMT in the Table based on the Percentage on the same line, would look like the following. *I'm assuming the Percentage is a whole number and not a decimal. I just using your field names for the in this calculation, you would need to substitute your variables.

=MULT(Amount,DIV(INDEX(Budget.Codes.%,ROW()),100))

Forms will likely get an error in this field when you Amount or % fields are empty because of the way Forms handles Errors, so you may what to wrap this in an if statement such as

=IF(OR(AMOUNT<1,%<1),0,MULT(Amount,DIV(INDEX(Budget.Codes.%,ROW()),100)))

Also, Make sure your % field is a number field

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...