It seems for this to work there has to be two citation templates (each having either a period or a comma) working simultaneously and this can’t be done in EndNote.
However, if you convert your final document to a text file to remove EndNote field codes it’s possible to create a macro in MS Word to automate searching and placing the punctuation either before or after the bracketed citation. Or instead of a macro you can just use Search and Replace.