Skip to main content
Question

make an autofill based on the number that shows another field.

  • August 8, 2018
  • 0 replies
  • 170 views

I need to make an autofill based on the number obtain from the substrack of 2 fields.

Ex.
1.-
Field "A" quintitie assure 100,000
Field "B" % charge              .4%
Field "C" total charged           400
Field "D" comission paid      0%

2.-
Field "A" quintitie assure 100,000
Field "B" % charge              .6%
Field "C" total charged           600
Field "D" commision paid    .1%

So field E I needed to be
  
Field "A" times  x points (If  in field B-D .4%= 3 points, If  .5%=5 point. If .6%= 7 points , all with commission considered) 

1.- 100,000 X  3 (.4%- .0%= .4%) = 300,000
2.- 100,000 x   5 (.6%-.1% = .5%) = 500,000


This topic has been closed for replies.

Perhaps you mean this for the formula for [Field E]

var number X = ([Field B] - [Field D]) * 1000;

[Field A] * $X