Use Quarter Rate for all months in Quarter

[bhargavikn]

Hi,

Can you please help me calculating Amount for months in Quarter based on Quarter rate.

Below is sample table:

				Output
Month	Amount	Rate_month	Rate_Quarter	Amount_Month	Amount_Quarter
April	100	1		100	300
May	100	2		200	300
Jun	100	3	3	300	300
Total:	300			600	900

We have individual rate for each month and Quarter rate is considering the max month rate.

While calculating the amount, for month wise calculation need to to monthly rate.

But for Quarter amount calculation, need to use max month rate for all months in Quarter. 

Please help me to achieve  Quarter Amount.

your help is highly appreciated.

Thank you.

[vinieme12 · Accepted solution]

Assuming you also have a QuarterYear field

1)  sum(Amount*Rate_month)

2) sum(Amount)*max(total <QtrYear> Rate_Quarter)

[bhargavikn]

Thank you Vineeth for solution. It is working.