Round() is throwing invalid error in cognos10

[inu]

Hi Tema,

Below expression was used in cognos 7. It worked and gave the output. But in cognos10 throwing error. See the attached file.

round(average(_add_days([Folders].[Events Job_Events].[Event_Date],0) - _add_days([Folders].[Events Schedules].[Etd_Date],0)),1)

If i am supposed to use any other function, then please suggest me.

I appreciate your valuable prompt response.

Regards
Inam

[R Ambre]

Hi ,

I have question regarding your expression.
I tried using your expression without applying round function.
I have created two data items one with Average and one without average ,I got same output for both the expressions ..so there is no need of applying average and round function.

Could you please tell me your exact requirement so that I can help you as much I can?