syntax error

hi

i am using this in iif

exp(sum(LOG(1 + Fields!item1.Value/100))) * 100

i m getting syntax error

the real exp is like this 

(exp(sum(LOG(1+field/100)))-1)* 100  , which i m using in iif ,true part,getting syntax error

try this

=exp(sum(Log(1+1/Field))-1)*100

but this is not my real expression,whatver logic is ther i need to apply that one only

=iif(exp(sum(Log(1-1/Field))-1)*100 >2,"some val","other val")

This is exemple what you can use in your iif statement

ok.

i ma using this expression in my query and getting this error

Arithmetic overflow error converting expression to data type float.

any idea?

Can you locate the error?

try this

=Log(1-1/Field)

after

=sum(Log(1-1/Field))-1

next

=exp(sum(Log(1-1/Field))-1)*100

and find out the step with error

its showing under log(1 + filed/100) under this

Can you show field values, that couse the error?