Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to count a particular set of ID numbers within a particular fiscal year. I have started with the code below, but it is currently not working. Can anyone help correct the code please?
Count({<[Event Date]={">=$((Date($(vMinFiscalYear),'DD/MM/YYYY'))) <=$((Date($(vMaxFiscalYear),'DD/MM/YYYY')))">}[IDs])
can you try
Count({<[Event Date]= {"<=$(=Date(vMaxFiscalYear,'DD/MM/YYYY')) >=$(=Date(vMinFiscalYear,'DD/MM/YYYY'))"}> } [IDs])