I want to run this expression in cognos 10.2.2 and it is giving me an error. Please Who can help me solve it?
The error is as follows:
An analysis error has occurred before or near position 162.
IF([MES]=MONTH(GETDATE()-1))
THEN ([Q_VENTA_AL_DIA].[PROMEDIO VENTAS DIARIO] * [Q_VENTA_AL_DIA].[DIAS TRANSCURRIDO MES])
ELSE (IF([MES]<>MONTH(GETDATE()-1)))
THEN ([Q_VENTA_ANIO].[PROM VENTAS ACUM ANIO] * [Q_VENTA_ANIO].[DIAS TRANSCURRIDO ANIO])