Re: NaN value on either a default value or through rule

JeffVojtko — Tue, 09 Sep 2014 19:09:58 GMT

Got the code fixed. See Below: concat(substring("", 1, (not(starts-with(ReportTitle, "BRKR") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "CAPSJ243") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "CLNKJ020") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "DISAXTOP") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "FLXPJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IAARJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IALDJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IAPSJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IADSJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IACO") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IACPJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IAPVJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "IATXJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "MKURJ522") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "PRPAJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "RXSCJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "RXSMJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "REVAJ") and ReportTitle != "" and contains(Media, "View")) or not(starts-with(ReportTitle, "PRPEJ") and ReportTitle != "" and contains(Media, "View")) or not(contains(Media, "View"))) * string-length("")), substring(concat(substring-before(UserIDNew, ";"), ",", substring(Action, 1, 1), ",", ReportTitle), 1, ((starts-with(ReportTitle, "BRKR") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "CAPSJ243") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "CLNKJ020") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "DISAXTOP") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "FLXPJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IAARJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IALDJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IAPSJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IADSJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IACO") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IACPJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IAPVJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "IATXJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "MKURJ522") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "PRPAJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "RXSCJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "RXSMJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "REVAJ") and ReportTitle != "" and contains(Media, "View")) or (starts-with(ReportTitle, "PRPEJ") and ReportTitle != "" and contains(Media, "View"))) * string-length(concat(substring-before(UserIDNew, ";"), ",", substring(Action, 1, 1), ",", ReportTitle))))

Re: NaN value on either a default value or through rule

JeffVojtko — Wed, 03 Sep 2014 18:47:24 GMT

Figured it out

Had a misplaced parenthesis

concat(substring("Bad", 1, (ReportTitle != "BRKR" and ReportTitle != "") * string-length("Bad")), substring(concat(substring-before(UserIDNew, ";"), ",", substring(Action, 1, 1), ",", ReportTitle), 1, (ReportTitle = "BRKR" and ReportTitle != "") * string-length(concat(substring-before(UserIDNew, ";"), ",", substring(Action, 1, 1), ",", ReportTitle))))

NaN value on either a default value or through rule

JeffVojtko — Wed, 03 Sep 2014 14:09:49 GMT

I am getting a NaN value in front of my desired test string. And, I can't seem to figure this one out.
Here is my formula:
concat(substring("Bad", 1, (ReportTitle != "BRKR" and ReportTitle != "")) * string-length("Bad"), substring(concat(substring-before(UserIDNew, ";"), ",", substring(Action, 1, 1), ",", ReportTitle), 1, (ReportTitle = "BRKR" and ReportTitle != "") * string-length(concat(substring-before(UserIDNew, ";"), ",", substring(Action, 1, 1), ",", ReportTitle))))

What I would like is to get a string like this:
BBC,A,BRKR

But, what I am getting is
NaNBBC,A,BRKR

The field types are:
ReportTitle - String
UserIDNew - String
Action - string

General

Re: NaN value on either a default value or through rule

Re: NaN value on either a default value or through rule

NaN value on either a default value or through rule