Invalid percentage list using PERCVAL function

[Jessica Astorga]

​Hi,

We're trying to generate data with DataMaker using the following function:

@seqlov(0,@perclist(0.02%NA,45.16%0,54.82%1)@)@

We get "invalid percentage list - percentages do not total 100" when we run the function but the percentages are doing a total of 100.

Is it possible to use decimal places in PERCLIST function?

Any suggestion about getting the expected result with other functions will be welcomed.

Currently using 4.9.0.126 CA-TDM Datamaker version.

Thanks in advanced,

Jessica.

[Klaas-Jan Lute]

Hi Jessica,

The function parameters are integers so that won't work. The only solution I can think of is a seedlist containing 10.000 records: 2(NA); 4516(0);5482(1). 
Note that whatever solution you choose, you won't get the requested percentages unless you create records in batches of 10.000. Creating 10.002 will result in a 0.04 percent NA.

Best regards,
Klaas-Jan Lute

[Jessica Astorga]

​Hi @Klaas-Jan Lute,
​
Thank you for the excellent suggestion about using a seedlist! It should suit our pursuit result.

Best regards,
Jessica.