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?
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
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.
no , i put 100.o ,my prob is still same