Recent searches


No recent searches

Meri Miettinen's Avatar

Meri Miettinen

Joined Oct 31, 2024

·

Last activity Oct 31, 2024

Following

0

Followers

0

Total activity

2

Votes

0

Subscription

1

ACTIVITY OVERVIEW

Latest activity by Meri Miettinen

Meri Miettinen commented,

CommentWriting formulas

Hi, I'm trying to calculate NPS from a custom numeric field. Could you help me fix this error with using [Changes - Field name] and [Changes - New value]? When I open the report that has this metric in it I get the following errror: “An error occurred. Contact Zendesk Customer Support (error code 7). (Error code: a19dd239)” 

 

Here is my standard calculated metric formula:

IF ([Changes - Field name] = "Surveypal NPS")
THEN
IF (NUMBER([Changes - New value])< 7)
THEN [Ticket ID]
ENDIF
ENDIF

The field Surveypal NPS is numeric field. I tried to use this without the “NUMBER” function but that gives error that the formula is wrong (mixing text and numbers). And I feel like if I put the number in quotes it works, but the calculation doesn't seem to work? So for clarity I tried this and it “works” but the results are not correct:

IF ([Changes - Field name] = "Surveypal NPS")
THEN
IF ([Changes - New value] < "7")
THEN [Ticket ID]
ENDIF
ENDIF

View comment · Posted Oct 31, 2024 · Meri Miettinen

0

Followers

0

Votes

0

Comments