Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
/Thanks in advance.
Best
Chanty
I think this should work. But if you have 1, 2, 3, 4 in Quarter field thin this:
=Max({<Quarter = {2}>}Month)
Max(Month)?
May be like this?
quarter={'Q2'},month={"$(=Max(Month))"}
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)
Hi Chanty,
What is the MonthOrder field values? What are you trying to acheive with this field?
=Max({<Quarter={'Q2'}>}Month)
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)