I have a report that pulls KPIs by Day for a date range entered by the user. I need to be able to exclude item on certain days during the year. The number of days and the dates to be excluded will change.
I thought I would create an ExcludedDays list similar to Ken Hamady’s HolidayList, then do a simple if/then formula on each row and use that for a key in my calculations.
I created this ExcludedDays formula.
Then I did the formula
That fails, saying a date range is required at {@ExcludedDays}.
Not sure if my problem is syntax, or if this is bad way to solve my problem. Please let me know what you think.
Thanks
I thought I would create an ExcludedDays list similar to Ken Hamady’s HolidayList, then do a simple if/then formula on each row and use that for a key in my calculations.
I created this ExcludedDays formula.
Code:
BeforeReadingRecords;
DateVar Array ExcludedDays :=
[
Date(2011,01,01),
Date(2011,01,04)
];
0
Code:
if {DVDN.row_date} in {@ExcludedDays} then 1 else 0
Not sure if my problem is syntax, or if this is bad way to solve my problem. Please let me know what you think.
Thanks