LSW Posted May 5, 2011 Report Share Posted May 5, 2011 In my query I have a mathematic function under an alias: (a amount+ b amount) AS "difference" Now however I need to sum the difference, but apparently you cannot sum information using an alias: SUM('difference') AS "total_difference" I get a ORA-01722: invalid number error. Any ideas? Quote Link to comment Share on other sites More sharing options...
LSW Posted May 5, 2011 Author Report Share Posted May 5, 2011 Nope, I guess you can't. Now if I could figure out how to get it in my Crystal Report without mucking up the other sums... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.