Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

division by zero - SQL 2000

Status
Not open for further replies.
chertel

chertel

Programmer
Apr 15, 2002
10
US
I am creating a cube in Microsoft SQL Server 2000. The Query of a calculated member returns text such as "1.#INF or 1.#J" instead of the number. Cause: The formula in the calculated member attempted to divide by zero. Solution: Change the formula to check for possible division by zero errors before they occur.

But...

***How do i write the statement using the Caculated Member Builder to do this?***

Please Help,
Carla
 
Status
Not open for further replies.

Similar threads

gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
332
pjw001
pjw001
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
358
Volvere
V
leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
195
dhookom
dhookom
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
284
Andrzejek
Andrzejek
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
229
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top