i am selecting 10 fields from a table .
can i use divide operator in select statemnt for caluculating the resultant filed which is not a column of the table, but the fileds paticipating in the divide operator are present in the table.
Here C-LI-CLC-ALLW-AMT, C-LI-ALLOW-UNT-NUM are fileds of a table but
PAID-AMOUNT-PER-UNIT is not a filed of this table or any other table. can i do the above operation in the select statement
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Suggest you build a prototype query with the operations you want to accomplish and we can help you get it running if there are problems.
When you post your code, please use the "Code" tag at the top of the reply panel for readability (green on black) as well as preserve alignment. Use Preview to see how your post will appear to the forum and when you are satisfied with the appearance, Submit.