Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

What triggers the error message "invalid multiplier" in SAINT Classification import?

Avatar

Avatar
Validate 1
Level 2
BarryLennon
Level 2

Likes

16 likes

Total Posts

41 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
BarryLennon
Level 2

Likes

16 likes

Total Posts

41 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
BarryLennon
Level 2

28-02-2018

I'm trying to import a numeric classification, but I'm unable to get past the warning:

  • Warning: Invalid Multiplier: '1'

This appears whenever I populate the final two columns with anything (the '1' part is because I tried filling the final column with 1's on the last go).

In the example below, "Amt" is the classification variable of type 'text', and then "Amt^~AmtN" is the 'numeric' classification variable.

I presume the variable ending "~per~" is meant to be the type of 'numeric' (it never changes, regardless of whether I select "percent", "number", or "currency").

  1. What does the error mean?
  2. What should go in "Amt" and its sub-classifications?

                                                          

##   SCSiteCatalyst SAINT Import Filev:2.0
## SC'## SC' indicates a SiteCatalyst pre-process   header. Please do not remove these lines.
## SCD:2018-02-28 08:55:46A:xxxxxxxxxxx:122
KeyFlagSystemDetailAmtAmt^~AmtNAmt^~AmtN^~per~
a13psref406.23
a14psref287.5
a15fschg458.33
a16fcref500
a17frrisk1015.83

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
joshd7227840
MVP

Likes

275 likes

Total Posts

241 posts

Correct Reply

70 solutions
Top badges earned
Contributor
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
MVP
joshd7227840
MVP

Likes

275 likes

Total Posts

241 posts

Correct Reply

70 solutions
Top badges earned
Contributor
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
joshd7227840
MVP

28-02-2018

There are specific configuration values you need to populate those columns with. Which value(s) to use depends on your needs.

See: PER Modifier Headings

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
BarryLennon
Level 2

Likes

16 likes

Total Posts

41 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
BarryLennon
Level 2

Likes

16 likes

Total Posts

41 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
BarryLennon
Level 2

01-03-2018

Thanks, Josh - that's exactly what I was after.

If I had cut my search down to just the word "multiplier", I would have found it - I was so close!