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     ...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Perhaps you mean this for the formula for [Field E]

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

[Field A] * $X




QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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.