Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 06 Aug 2015 01:38:29 PM

Title: Round() is throwing invalid error in cognos10
Post by: inu on 06 Aug 2015 01:38:29 PM
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
Title: Re: Round() is throwing invalid error in cognos10
Post by: R Ambre on 07 Aug 2015 06:22:54 AM
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?
Text only | Text with Images