Announcements
cancel
Showing results for
Did you mean:
MVP

## RE:Max in Quarter

Hi all,

I have  a  fileds lik

orderdate,

year,

quarter,

month

day,

so  in quarter i hve  Q1,Q2,Q3,Q4

so i need to Pick   Q2 max month  in set analysis

how can i get this  Max month?

Best

Chanty

1 Solution

Accepted Solutions
MVP

I think this should work. But if you have 1, 2, 3, 4 in Quarter field thin this:

=Max({<Quarter = {2}>}Month)

7 Replies

Max(Month)?

talk is cheap, supply exceeds demand
Master III

May be like this?

quarter={'Q2'},month={"\$(=Max(Month))"}

MVP
Author

Hi settu,

set analysis i want to pick max month in Quarter 2 .my field name is qtr 1,2,3,4,

eg:sum({<FY={\$(=Max(FY))},Qtr={'2'},MonthOrder = {"\$(= max({<FY={\$(=max(FY))}>} MonthOrder)-8)"}>} Amount)

Champion

Hi Chanty,

What is the MonthOrder field values? What are you trying to acheive with this field?

Specialist III

=Max({<Quarter={'Q2'}>}Month)

MVP

I think this should work. But if you have 1, 2, 3, 4 in Quarter field thin this:

=Max({<Quarter = {2}>}Month)

try this

=sum({<FY={"\$(=Max(FY))"},Qtr={"2"},MonthOrder = {"\$(= max({<FY={"\$(=max(FY))"},Qtr={"2"}>} MonthOrder))"}>} Amount)

Community Browser