View Creation Multiply Database Columns

@kevin may I know the type of both the column which you are trying to multiply. Also try using sum(column1*column2) as column3 while working with Oracle database

Make sure column1 as well as column2 should be of type Number(_) or Number(_,_) for decimal

They are both integer types.

Try using sum(col1*col2)

It's giving the same error.

Can you share the error code starts with ORA-

There isn't an error code. It's just a message from a pop up that displays, "You cannot perform a * query."

Take the spaces out, so you have (column1*column2)

I worked for me, i just tried select col1*cal2 from table1. May the SQL client that you are using is not liking the *. Can you share the screenshot of the error?

I attached a copy of the SQL query that I am using for the Query Database Smart Service. As far as I know, I'm required to use double quotes for table names and columns. I removed the spaces and it still gives me the error, "You cannot perform a * query."

The version of Appian I'm using is 7.11, I don't know if that really matters.

PMT_RiskViewQueryMod.txt