CUIC 11 Formula field return ERR

[michales]

HI,

CUIC 11.0 report: formula field return 'ERR' when dividing two fields ${Field1} / ${Field2} how to avoid this?

regards,

Michael Sagi

[rajagkri]

Hi,

So you want to display "0" in case of division by zero? Why do you need this? Is it because you want to export the report as a spreadsheet and then do some calculations?

Regards,
Rajagopal

[michales]

Hi Rajagopal,

Thanks for your reply,

No, the customer does not want to see the word ERR in the report. I have to show 0 instead of ERR, how can i do this.

Regards,

Michael

[Gerry O'Rourke]

Michael,

I had the same issue and raised a TAC case.

The bug was corrected for 11.5 but not for 11.0.

But now it has been fixed and is available on COP 7

See below.

"This defect(CSCux84714) already backported and will be available in 11.0(1) COP7."

Regards,

Gerry

[etmarcof]

Hi,

Regarding CUIC Formula Field  where i can find functions that i can use.

I need to extract Month and Year from  ${DateField} is there one Function for that?

Regards,

[rajagkri]

Hi - Here is the documentation on Formula Fields:

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/intelligence_suite/intelligence_suite_1105/user/guide/cuic_b_cisco-unified-intelligence-center-report/cuic_b_cisco-unified-intelligence-center-report_chapter_0110.html?boo...

Regards,
Rajagopal