error converting expression to float

hi

i m using this expression in my query

EXP(sum(log(1+ field/100)))-1) * 100

it gives me error like arithmetice overflow error converting expression to data type float.

how to solve that

What are some of the values that this expression returns?

sum(log(1+ field/100)))-1

What is the greatest value it returns?

I suggest you use this expression for some troubleshooting first before adding the EXP and * 100.

it seems like both exp and log are return float and sum is return integer ,so if i remove sum,it works fine,

but i need sum in my formula

what to do

Hi ssrsnew.

Have you tried to replace 100 with 100.0? Something like this:

EXP(sum(log(1+ field/100.0)))-1) * 100

I believe that is your problem.

Let me know if that solved you problem. If so, mark this reply as the answer please.

Best Regards.

no , i put 100.o ,my prob is still same