Error: "The Expression is too complex"

[johnnitt]

Hello,

I receive the following error "This expression is typed incorrectly, or it is too complex to be evaluated. For Example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables"

Here is the expression that causes the error:
Clos_Score: 1-Exp([Rur_Calc])/1+Exp([Rur_Calc])

The expression is referencing this expression which has no errors:

Rur_Calc: 5.4698+3.2626*[FLLCACL]-1.0891*[FLLTATL]-16.7608*[FLLTAPTR]-1.7131*[FLLTRTEQ]-1.8298

I put an actual number in the for Rur_Calc in the expression that gives me the error and there are no errors, so I am assuming the Expression is too complex? Any suggestions to correct this error would be greatly appreciated since this is thee last step of my calculation.

Thanks!

[mcupito]

Did you try:

Clos_Score: (1-Exp([Rur_Calc]))/(1+Exp([Rur_Calc]))

?

Be weary of calculations in queries - don't forget your order of operations.

[johnnitt]

Yes, I tried that and same error. I mentioned in my original post that when I put a fixed number in the place of [Rur_Calc] the calculation is correct, but [Rur_Calc] appears to be a complex expression.

[mcupito]

Are you trying to reference an expression that you are compiling in the same query? That won't work.

For example, if I have the expressions:

Increase: [FinanceTbl]![Total] - [FinanceTbl]![Expenses]

And I try to use [Increase] in the same query, it won't work. You must create a new query and use your existing query as the foundation Edit: Or see ADezii's post.

[ADezii]

Try including the Expression within [Clos_Score] directly and see what happens:

Clos_Score: 1-Exp(5.4698+3.2626*[FLLCACL]-1.0891*[FLLTATL]-16.7608*[FLLTAPTR]-1.7131*[FLLTRTEQ]-1.8298)/
1+Exp(5.4698+3.2626*[FLLCACL]-1.0891*[FLLTATL]-16.7608*[FLLTAPTR]-1.7131*[FLLTRTEQ]-1.8298)
5.4698+3.2626*[FLLCACL]-1.0891*[FLLTATL]-16.7608*[FLLTAPTR]-1.7131*[FLLTRTEQ]-1.8298

[johnnitt]

Your advice worked. Thank You!

[ADezii]

You are quite welcome.