Removing N/A's from a Table

[hammermill21]

Hi, I have a table with the measure $(fComplianceScore) which is calculating scores but I need to add for it to remove any total that is 0% or N/A. How can I do that?

Thank you!

[arulsettu]

can you share expression inside the variable

[hammermill21]

Of course!

Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)

[arulsettu]

N/A is a value from Score? can you share a sample app

[hammermill21]

It's actually "0" but in the script, I have this:

LOAD RecNo() as ID,

Replace([Facility Temp],'UMHC ','') as Facility,

       If([Score Temp]=0,'N/A',[Score Temp]) as Score,

I just need to remove those N/A for this one table

[hammermill21]

I attached the sample to the original post above.

[arulsettu · Accepted solution]

maybe like this

if((Alt(Sum({<Score={">0"}>}Score)/Count({<Score={">0"}>}[Record ID])))>0,

Alt(Sum({<Score={">0"}>}Score)/Count({<Score={">0"}>}[Record ID])/3,0))

[hammermill21]

I tried something like that and it doesn't seem to work, it throws all the numbers off for some reason.

[agigliotti]

what you get with the below expression:

=Alt( Sum( {< Score = {">0"} >} Score ) / Count( {< Score = {">0"} >} [Record ID] ) /3, 0 )

?

[hammermill21]

I think I got it, with what you sent me. Thank you!