We have used virtual columns with simple arithmetic but the column does not work properly when used in a simple SELECT statement with JOIN. Here are the column definitions of relevant fields: