Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Use Quarter Rate for all months in Quarter

Hi,

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.

Thank you.

Labels (2)

• ### QlikWorld 2023

1 Solution

Accepted Solutions
Champion III

Assuming you also have a QuarterYear field

1)  sum(Amount*Rate_month)

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
2 Replies
Champion III

Assuming you also have a QuarterYear field

1)  sum(Amount*Rate_month)

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Contributor III
Author

Thank you Vineeth for solution. It is working.