i have a saved search formula in the highligting bar as below.
case when (to_char({requesteddate},'DY') = 'FRI' AND sum( case when {quantity} > 0 then 1 else 0 end )>= 500 ) OR ( to_char({requesteddate},'DY') != 'FRI' AND sum( case when {quantity}> 0 then 1 else 0 end )>= 500 ) OR (to_char({requesteddate},'DY') = 'FRI' AND sum( {quantity})>=4000 ) OR ( to_char({requesteddate},'DY') != 'FRI' AND sum( {quantity})>= 4000 ) then 1 else 0 end
I want to include this into the script to mimic the saved search. could anyone please help?