1 person found this helpful
If you are using text based multiperiod loads then the use of an import format is still valid so just use the NZP expression in the Amount field. Are you talking about Excel based loads?
Its text based load, we have already defined the number of amount columns in the Expression field.
Columns=start,end values. For e.g. Column=11,22 for the amount fields.
Where to add NZP? We had also tried adding in the same expression but it did not worked.
Can you please provide an example.
Simon provide you the correct answer. The separator would be a ;
A simple example would in your case would be Column=8,19;NZP
Hope that helps and let us know how that makes out.