I have the following query on oracle 12.1.1 database
I am trying to use either NVL or IFNULL function on the following query but keep getting an error( 00909. 00000 - "invalid number of arguments"). can I use it on one column or has to be applied on all columns?
(((CAST(SIMULATION_SCR AS NUMBER) - 57.81114) / 24.79211) + ((CAST(MIN_WPM_SCR AS NUMBER) - 40.7836082505127) / 17.5946375921401)
+ ((CAST (NVL(SLOT4 AS NUMBER),0) - 49.4958123953099) / 27.9601909416896) ) / 3 BASE_BAND.