Distribution of numbers automatically

[marcel_olmo]

Hi guys,

I have a budget of get  100 new customers per year and I'd like to distribute the budget over the months.

A simply way would be divide 100/12 and write it one per month, but it wouldn't be nice, I'd prefer to assign natural numbers.

Something like this :

Month	Customer Budget
ene	9
feb	9
mar	9
abr	9
may	8
jun	8
jul	8
ago	8
sep	8
oct	8
nov	8
dic	8
Total	100

Regards, Marcel.

[rubenmarin]

Hi Marcel, you can adapt to your requirements this epxression:

Floor(100/12)+If(Month<=Mod(100,12), 1, 0)

[anbu1984]

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Load *,If(IterNo() <= Rem, BudgetTemp + 1,BudgetTemp) As NewBudget,SubField('$(MonthNames)',';',IterNo()) As MthNm While IterNo() <= 12;
Load *,Floor(Budget/12) As BudgetTemp,Mod(Budget,12) As Rem Inline [
CustID,Budget
1,100
2,120 ];