I am trying to fetch min date in my report in webi.The report is build from 01/01/2018 till 10/31/2018 for two different promos. But these promos began and ended beyond report start and end dates ie 01/01/2018 till 10/31/2018.
I have tried different functions but nothing has worked.
<code>="Promo # "+[Promo Number]+": "+Min([Date]) In([Promo Number])+" - "+Max([Date]) In([Promo Number]) //what should i edit here
Min date gets defaulted to report start date 01/01/2018 and max date to 10/31/2018.
But in actual min date is 03/05/2016 and max date is 11/30/2018.
Promo # 183: 1/1/2018 - 4/14/2018(end date is correct since its in the report date range)
Promo # 200: 5/1/2018(start date is correct since its in the report date range) - 10/31/2018
Promo # 183: 03/05/2016 - 4/14/2018
Promo # 200: 5/1/2018 - 11/30/2018
Report dates should not affect the start and end date for promos