We have created reusable macro which was used in many reports with 3 parameters and that macro is starting point of query. one parameter takes Month (i.e 02/01/2017 ...) from filter. Now i got requirement where i need to provide current month/previous month to macro as parameter . Since query begins with macro i unable to create eval expression .
query:
|eval month = strftime(now(),"%m/01/%Y") | 'ADForecast("$Domain$,month)'
since ,we cannot start a query with eval i unable to pass current month. please suggest how to pass current month.
... View more