G
Guest
I am getting a "Division by zero error" in my pass-through query.
Here is my Select statement
SELECT
CD_CODE,(SUM(HP_SYSTEM_EXPECTED_BOOKINGS)/SUM(TOTAL_NET_BOOKINGS))*100 AS
SYSTEMSHARE
The error is because of a zero sum of Total_Net_Bookings.
How can I put a IF statement here to say if Sum(Total_Net_Bookings) = 0,
then SystemShare = 0 else ......
Any ideas?
Here is my Select statement
SELECT
CD_CODE,(SUM(HP_SYSTEM_EXPECTED_BOOKINGS)/SUM(TOTAL_NET_BOOKINGS))*100 AS
SYSTEMSHARE
The error is because of a zero sum of Total_Net_Bookings.
How can I put a IF statement here to say if Sum(Total_Net_Bookings) = 0,
then SystemShare = 0 else ......
Any ideas?