Discussions

Expand all | Collapse all

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

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

    Posted 08-07-2018 23:21
    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




  • 2.  RE: make an autofill based on the number that shows another field.

    Posted 08-07-2018 23:30
    Perhaps you mean this for the formula for [Field E]

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

    [Field A] * $X






  • 3.  RE: make an autofill based on the number that shows another field.

    Posted 08-07-2018 23:53
    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


  • 4.  RE: make an autofill based on the number that shows another field.

    Posted 08-07-2018 23:59
    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.


  • 5.  RE: make an autofill based on the number that shows another field.

    Posted 08-08-2018 00:23
    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


  • 6.  RE: make an autofill based on the number that shows another field.

    Posted 08-08-2018 12:23
    If you want to make a field for the points called [Points], then use

     ([Field B] - [Field D]) * 1000;

    The then field for the final results would be

    [Points] * [Field A]




  • 7.  RE: make an autofill based on the number that shows another field.

    Posted 08-08-2018 20:35
    Hi again Coach,

    I tried to use this formula but it seems I am writing something wrong.

    If([Cuota]=".35",1, [Cuota]=".6", 7)

    where cuota is field B= .35 should come to 1 point, if cuota .6 then should come to 7 points.

    I get this message

    The expression [Cuota] on the left hand side of the operator "=" is of type number while the expression ".35" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions.
    You may need to do one of the following to fix the problem:
    • Add a type conversion function.
    • Choose a different operator.



  • 8.  RE: make an autofill based on the number that shows another field.

    Posted 08-08-2018 20:37
    try this

    If(
    [Cuota] = .35,1,
    [Cuota]= .6, 7)


  • 9.  RE: make an autofill based on the number that shows another field.

    Posted 08-10-2018 15:21
    Thank you coach, it worked perfect.

    Have nice day.


  • 10.  RE: make an autofill based on the number that shows another field.

    Posted 08-20-2018 19:16
    Hi again Coach,

    Is it posible to have a range instead of a number? I tried this formula but think wrote it wrong. If between .001 and .00348 then have 1

     If([Cuota]>=0.001,[Cuota]<=0.00348),1




  • 11.  RE: make an autofill based on the number that shows another field.

    Posted 08-20-2018 19:49
     If([Cuota]>=0.001 and [Cuota]<=0.00348),1,
    .....


  • 12.  RE: make an autofill based on the number that shows another field.

    Posted 08-20-2018 20:01
    Soeey is not working, I get this massage!

    Formula syntax error

    There are extra characters beyond the end of the formula.

    If([Cuota]>=0.001and[Cuota]<=0.00348),1



  • 13.  RE: make an autofill based on the number that shows another field.

    Posted 08-20-2018 20:26
    I was just giving you a part of a formula and showing how to use the "and".

    I don't know what you want the whole formula to do.  If you just want it to do that one thing, then just close the bracket.

    If([Cuota]>=0.001 and [Cuota]<=0.00348),1)






  • 14.  RE: make an autofill based on the number that shows another field.

    Posted 08-20-2018 21:09
    great thank you