i have created two parameters ?WeekNo and ?YearNo using one date field from my table, the first one i need to convert it to weeks and the other one to years and in my formula i need to create something like:
if {table.field} <> 0 then
select count(*) from table
where table.Datefield = ?WeekNo and table.Datefield = ?YearNo / select {table.field} from table
how do i get a workaround that?