Scoring Matrix

[Ciara]

I might be over complicating something that could be super easy but can't seem to figure out how to do it.

I want to create a scoring matrix for new entries into a dictionary.

I have created 8 different criteria and if the condition is met I give it a value of 1 otherwise its given 0.  Like below:

              If(IsNull(ProviderTitle), 0, 1) as ProviderTitleScore,

              If(IsNull(ProviderType), 0, 1) as ProviderTypeScore,

              If(WildMatch(ProviderName, '*,*'), 1, 0) as ProviderNameScore.................. etc

What I'm looking to do is to sum all 8 'scores' together and have an overall score for each Provider.

Any help is appreciated.

Thanks

Ciara

[dplr-rn · Accepted solution]

maybe i am not getting the core of the issue.

why not ProviderTitleScore+ProviderTypeScore+ProviderNameScore+..... etc.

?

[Ciara]

Oh my goodness.......I did something very stupid and had my syntax wrong and it kept giving me an error 🙈

It's been a looooooooooooong lockdown so far 😂

Thanks Dilipranjith.  Apologies for my silly question.