Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey all
I am running into a problem when using set analysis in order to analyse previous months. I have a field called Period (DD.MM.YYYY) and created year(Period) as well as month(Period) from it. These new fields should serve as navigation. In order to calculate the SetAnalysis i apply the field Period. Unfortunately it is not working when only selecting a year and a month.
Attached you will find an example file.
cheers
Sebastian
add to your set analysis Jahr=,Monat=
because when you select a specific Year, and Month then previous 2 months are out of selection
check attached
add to your set analysis Jahr=,Monat=
because when you select a specific Year, and Month then previous 2 months are out of selection
check attached
=count({<Periode = {'$(==Date(AddMonths(MakeDate(Max(Jahr),Max(Monat)),-2)))'}>}[Server physisch/virtuell])
If this is not working, kindly provide sample data in excel file....
use max function like below
=count(
{<Periode = {'$(=addmonths(max(Periode),-2))'}>}
[Server physisch/virtuell])
This formula worked perfectly, while the others didn't. Thank you!!
Talking about the other ones, both worked when i only extracted the date calculation to a textfield. Eg: ='$(=addmonths(max(Periode),-2))'}
The moment i added it to SetAnalysis it refused to work though. Any explanation for that?