Cal on a Form

[gumby]

Why does this not work correctly on a form.

=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]

I do not get the correct answer. What am I doing wrong. I want to be
able to show the avg on the form of several Test Boxes.

Thanks,
David

 

[Guest]

Note that your expresson is = to:
=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]
=2*[T1]*[T2] +
3*[T3] +
4*[T4]/[T5]

Can you send some Tx samples and the result you are getting?

jouj

 

[Guest]

Hi,
I've just realized that you've posted your question again in another thread.
If you did not get a satisfied answer, please send the exact expression
you're writing, some Tx samples and the result you are getting.

Regards,
jouj

Note that your expresson is = to:
=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]
=2*[T1]*[T2] +
3*[T3] +
4*[T4]/[T5]

Can you send some Tx samples and the result you are getting?

jouj

Why does this not work correctly on a form.

=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]

I do not get the correct answer. What am I doing wrong. I want to be
able to show the avg on the form of several Test Boxes.

Thanks,
David