Split revenue (quarter) over months

[#1]

Hi guys,

I have the field revenue on a quarterly basis and want to split the revenue equally over every month. Can someone give me an example how to do this?

Example:

Revenue Q1: 300$ should be split into:

Jan. 100$,

Feb. 100$,

March 100$

Many thanks,

Harry

[#2]

Hey Harry,

Maybe something like attached?

Thanks

[#3]

Hi Ajay,

Many thanks! That's exactly what I want to do. I tried to apply your example to my case:

I have a StartDate and EndDate (3 months (quarter)) and in my master calender [month year]. However I tried to split my revenue based on the start and end date and connect it to [year month]. But I cant get the revenue split. Its always at the first month of the quarter.

Any ideas?

Many thanks,

Harry 

[#4]

Can you pls attach a sample of your file?  That would be really helpful in debugging.

[#5]

Hi guys,

I tried the following but without any success:

FOR i = 0 to 2 step 1

LEFT JOIN (Period)

LOAD

%PeriodId,

AddMonths(Date(Period.StartDate), $(i)) as Period.StartDate,

Revenue/3 as Revenue

RESIDENT Period;

NEXT

Any ideas?

Thanks,

Harry

[MarcoWedel]

Hi,

one solution could be:

LOAD Month(Date#((Right(Quarter,1)-1)*3+IterNo(),'M')) as Month,
    Money(Revenue/3) as Revenue
Inline [
Quarter, Revenue
Q1, 100
Q2, 200
Q3, 500
Q4, 1000
]
While IterNo()<4;

Instead of loading inline you would load from your source.

hope this helps

regards

Marco