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

[BarryLennon]

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?

##   SC	SiteCatalyst SAINT Import File	v:2.0
## SC	'## SC' indicates a SiteCatalyst pre-process   header. Please do not remove these lines.
## SC	D:2018-02-28 08:55:46	A:xxxxxxxxxxx:122
Key	Flag	System	Detail	Amt	Amt^~AmtN	Amt^~AmtN^~per~
a13	p	s	ref	406.23
a14	p	s	ref	287.5
a15	f	s	chg	458.33
a16	f	c	ref	500
a17	f	r	risk	1015.83

[josh_donley · Accepted solution]

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

[BarryLennon]

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!