cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
376
Views
0
Helpful
5
Replies
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
Cisco Employee

Re: CUIC 11 Formula field return ERR

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

Beginner

Re: CUIC 11 Formula field return ERR

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

Contributor

Re: CUIC 11 Formula field return ERR

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
Beginner

Re: CUIC 11 Formula field return ERR

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,

Cisco Employee

Re: CUIC 11 Formula field return ERR

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards