topic Re: if condition to include certain values and exclude some values in Reporting Service & Alerting

if condition to include certain values and exclude some values

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

Hi I'm trying to write an if condition, here A55 also includes A55.1,A55.2 and so on, I would like to include A89.91 and exclude A64.3, please advise

=if(Match(Left("Codes",3),
'A55',
'A56',
'A57','A58','A59','A60','A61','A62','A63','A64',
'A65',
),'yes','no')

Re: if condition to include certain values and exclude some values

agigliotti — Fri, 12 Aug 2022 14:31:06 GMT

Hi @smanas ,

Maybe this:

=if(Match( Left(ABISCA,3),
'A55',
'A56',
'A57','A58','A59','A60','A61','A62','A63','A64',
'A65',
) and ABISCA <> 'A64.3',
'yes',
if( ABISCA = 'A89.91',
'yes','no'
)
)

I hope it can help.

Best Regards

Re: if condition to include certain values and exclude some values

romansysyuk — Fri, 12 Aug 2022 14:46:46 GMT

map_codes:
Load * Inline [key, value
A55, yes
A56, yes
A57, yes
A58, yes
A59, yes
A60, yes
A61, yes
A62, yes
A63, yes
A64, yes
A65, yes
];

Load ApplyMap('map_codes', Subfield(Codes, '.', 1), 'no') as [flag column]
...

Re: if condition to include certain values and exclude some values

smanas — Fri, 12 Aug 2022 15:59:48 GMT

=if(Match(Left('ABCD',3),
'A55',
'A56',
'A57','A58','A59','A60','A61','A62','A63','A64',
'A65','A89.91',
),'yes', if(Match(Left('ABCD',3),'A64.3'),'no'))

Hello @agigliotti , is this correct?

Re: if condition to include certain values and exclude some values

agigliotti — Thu, 18 Aug 2022 09:38:30 GMT

Did you check my suggestion?

Re: if condition to include certain values and exclude some values

smanas — Fri, 19 Aug 2022 16:33:17 GMT

Hi @agigliotti it worked thanks a lot