Expression in cognos 10.2.2

0

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])
    
asked by Rass 19.04.2018 в 22:04
source

0 answers