Minor help with a formula. 1

[HookEmHorns]

I need to filter out one ImmunCode from this logic and wanted to check with the experts before I did it. I need to exclude where ImmunCode = "90715". Would I just add a line after 90698 that would read AND {cusASIISC_ImmunizationsGet.ImmunCode} <> "90715"?

if (
{cusASIISC_ImmunizationsGet.Category} = "Diphtheria, Tetanus, Pertussis" or
{cusASIISC_ImmunizationsGet.ImmunCode} = "90696" or
{cusASIISC_ImmunizationsGet.ImmunCode} = "90723" or
{cusASIISC_ImmunizationsGet.ImmunCode} = "90698"
) then
{cusASIISC_ImmunizationsGet.ImmunDte} else
date(9999,9,9)

 

[lbass]

Are you trying to exclude DTP rows that have code 90715? Or do you really want to exclude some group if it contains the value 90715 in any of its details?

-LB

 

[HookEmHorns]

90715 falls into the "Diphtheria, Tetanus, Pertussis" Category. This is the only one that needs to not pull into this range, as its pulling into another one I have set up.

 

[lbass]

Then change the formula to:

if
(
(
{cusASIISC_ImmunizationsGet.Category} = "Diphtheria, Tetanus, Pertussis" and
{cusASIISC_ImmunizationsGet.ImmunCode} <> "90715"
) or
{cusASIISC_ImmunizationsGet.ImmunCode} = "90696" or
{cusASIISC_ImmunizationsGet.ImmunCode} = "90723" or
{cusASIISC_ImmunizationsGet.ImmunCode} = "90698"
) then
{cusASIISC_ImmunizationsGet.ImmunDte} else
date(9999,9,9)

-LB

 

[HookEmHorns]

lbass -

You are a rockstar! Happy new year to you!