topic Re: Flag in Reporting Service & Alerting

Flag

smanas — Fri, 15 Nov 2024 22:04:35 GMT

Hello,

I have a column with numbers ranging from 1 to 15, I want to create a flag such as if number is 1 - Primary if the number is 2 and greater secondary into a new column, please advise thank you

Re: Flag

BrunPierre — Fri, 12 Aug 2022 16:45:51 GMT

IF([Number Column]='1','Primary',

IF([Number Column]>'1','Secondary',NULL())) AS [New Column]

Re: Flag

smanas — Fri, 12 Aug 2022 18:16:28 GMT

Hi @BrunPierre thanks for the query, but it's giving me an error

I think AS is not accepted

Re: Flag

BrunPierre — Fri, 12 Aug 2022 21:00:52 GMT

That statement should be in the script, then perhaps the resultant field i.e. [Primary/Secondary] will be used as a dimension against an expression like Count(distinct DiagnosisCD ).

I hope this helps or better yet share what you want to achieve.