Forum Discussion

ManuelAlvarez's avatar
ManuelAlvarez
Qrew Trainee
7 years ago

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

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


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

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

    [Field A] * $X




    • ManuelAlvarez's avatar
      ManuelAlvarez
      Qrew Trainee
      Thank you for quick answer,

      actually I want that B-d = .4 than to considered  3 points to multiply A
      if  B-D= .5 then to considered 5 points multiply by A
      if B-D= .35 then to considered only points 2 multiply By A 
      if B-D= .6 then to considered points 7 multiply By A 

      .35=1 
      .4= 3
      .5= 5
      .6= 7

      I want to make a relation between result and the points. I want to autofilled
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      Did you try the formula I suggested?

      Please try the formula and if it is not working how you want please tell me the result is giving and the result you expected.
    • ManuelAlvarez's avatar
      ManuelAlvarez
      Qrew Trainee
      It worked but I want to give like a preset value for the points, perhaps I need to work to steps. 
      Field E  which convert result from B-d. When ever I get .4% I want 3, when ever I get .6% I get 7 and so on. 
      And then another field lets say F, which multply Field A times Field E