supportsvc
Technical User
Hello,
Report is to show data for each week based on a date range prompt
I have this formula but it errors saying the {?DateRange} prompt I get an error
"A date is required here." with the {?DateRange} highlighted
Report is to show data for each week based on a date range prompt
I have this formula but it errors saying the {?DateRange} prompt I get an error
"A date is required here." with the {?DateRange} highlighted
Code:
If DataPart("ww", ({TransactionDate}) = DatePart("ww",{?DateRange}) then Sum({TransactionQty}) else 0)