Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I wonder what is the correct way to write this expression:
Count( {$<price_ok = {N} , date <= {Today()-7} >} pk_oc )
post your doc, if possible
or remove the label of the expression with set analysis and you could see the expression as that in the image to check it
the format of the field and the format of the date must be the same
considering the table of the previous example
did you see my comment regarding the single quotes for ocd_precio_ok ?
Yes, i try, but nothing changes
so Count( {$<ocd_precio_ok = {'N'} >} ocd_cmtrlsap) and Count( {$<ocd_precio_ok = {N} >} ocd_cmtrlsap) gives you the same number ?
Try this may be this might give you the result you are looking for.
=Count( {$<ocd_precio_ok = {N}, occ_fentr = {"$(='<=' & Date(Today()-7,'DD/MM/YYYY'))"} >} ocd_cmtrlsap)
Hi, here I upload a sample file so that they can understand better. Thanks for the support
Column should have all the records (6), but only column B that has a date (column C) above or equal to 08/05/2015 (4)
maybe this
Count( {$<ocd_precio_ok = {N}, occ_fentr = {"<=$(=Date(Today()-6,'DD/MM/YYYY hh:m:ss tt'))"} >} ocd_cmtrlsap)