- Home
- Anonymous
- Sign in
- Create
- Ask a question
- Spaces
- Site Issues (NOT FOR DATABASE QUESTIONS)
- Explore
- Topics
- Questions
- Users
- Badges

Dears, I have to convert a xls formula to sql, but Im havinfg some problems with power function, can anyone help me on that, the formula looks as below: (AX10+AY10)/(SQRT((AX10+AY10)^2+(AZ10+BA10)^2))) I tried in this way but it wont work.. (([fld1]+[fld2])/(SQRT(([fld1]+[fld2])POWER(2)+[fld3]+[fld4])power(2)))) I appreciate your help, Thank you in advanced

sqlmathematics
Comment

In what way does it not work? Does it give you an incorrect answer, or is it erroring?

No one has followed this question yet.

Copyright 2022 Redgate Software.
Privacy Policy