cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
543
Views
0
Helpful
5
Replies
Highlighted
Beginner

CUIC 11 Formula field return ERR

HI,

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

5 REPLIES 5
Highlighted
Cisco Employee

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

Highlighted

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

Highlighted

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

Highlighted

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,

Highlighted
Content for Community-Ad