Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to make a Setanalysis expression but until now without success.
I want exclude Brands where (365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <$(vL4LNrDays)
Could you give me an hand
Thanks
Bruno
=
Sum({$<MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
CalendarType = {$(=vCalendarType)},
MonthOrder = ,
Date = {"<=$(=Max(Date))"},
Year = ,
FiscalYear = ,
Quarter = ,
Period = ,
Week = ,
[Period (#)] = ,
[Brand Code]= E({$<_Inactive_Brand={'1'},
Date = {">=$(=min( $(=$(vSetRolling12)) Date)) <=$(=max( $(=$(vSetRolling12)) Date)))"}> }
>}),
Month = >} [#Sales EUR])
//(365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <$(vL4LNrDays)
Maybe this:
sum({<
MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
CalendarType = {$(=vCalendarType)},
MonthOrder = ,
Date = {"<=$(=Max(Date))"},
Year = ,
FiscalYear = ,
Quarter = ,
Week = ,
[Period (#)] = ,
Month = ,
[Brand Code]={'=(365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <$(vL4LNrDays) and Sum({$(vRolling12)} _Inactive_Brand)<1'}
>}
[#Turnover EUR])
I don't know exactly what you're looking for... Date function needs parenthesis.
However, start by combining (365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) in 1 variable so in your set analysis it'll be easier to evaluate.
See here
Hi Gysbert
I’m uploading my app to demonstrate my issue.
You ‘ll find a last column “Like For Like”. In this column I´m filtering the inactive Brands, but I need filter Brands that in the last Rolling12 have 365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <5
Thanks in Advance
Bruno
Maybe this:
sum({<
MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
CalendarType = {$(=vCalendarType)},
MonthOrder = ,
Date = {"<=$(=Max(Date))"},
Year = ,
FiscalYear = ,
Quarter = ,
Week = ,
[Period (#)] = ,
Month = ,
[Brand Code]={'=(365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <$(vL4LNrDays) and Sum({$(vRolling12)} _Inactive_Brand)<1'}
>}
[#Turnover EUR])
FANTASTIC.
Many Thanks Gysbert.
I was completely in the wrong direction. I thought this was only possible with P () and E (). I have a question. Why use single quote instead of double Quotes.
Thnks
Bruno