Hello to everybody.
I’ve created a new discussion because the old one had problems.
I have a question. What is the difference between the following two expressions? I thought in my "inexperience" that the values should be equal but they are not.
I need your help to understand what is happening.
Expression1
=Sum({$<MonthID = {"<=$(=Max(MonthID))"},
CalendarType={"Fiscal"},
Date = {"<=$(=Max(Date))"},
Year = {$(=Max(Year))},
Week = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = >}[#Turnover EUR])
Expression2:
=Sum({$<MonthID = {"<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year = {$(=Max(Year))},
Week = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = >*<CalendarType={"Fiscal"}>}[#Turnover EUR])
The use of the "*" in the second expression intends to intersect with the lines of the "calendar table", in which CalendarType= "Fiscal".
My first expression doesn't return the correct data, because the Max(MonthID) for same year in calendartype="Fiscal" isn't same of other calendar type (eg:
Gregorian).
I've three calendars in the same table, with a identifier which is CalendarType.
My intention is to pass the calendar type as an variable, but for now i'm only testing values.
I 'll apreciate very much your help.
Bruno