bhargavikn
Contributor III
2023-08-01
03:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use Quarter Rate for all months in Quarter
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.
1 Solution
Accepted Solutions
vinieme12
Champion III
2023-08-01
05:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If a post helps to resolve your issue, please accept it as a Solution.
2 Replies
vinieme12
Champion III
2023-08-01
05:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If a post helps to resolve your issue, please accept it as a Solution.
bhargavikn
Contributor III
2023-08-02
05:17 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Vineeth for solution. It is working.