Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
can you share expression inside the variable
Of course!
Alt(Sum(Score)/Count({<Score={">0"}>}[Record ID])/3,0)
N/A is a value from Score? can you share a sample app
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
I attached the sample to the original post above.
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))
I tried something like that and it doesn't seem to work, it throws all the numbers off for some reason.
what you get with the below expression:
=Alt( Sum( {< Score = {">0"} >} Score ) / Count( {< Score = {">0"} >} [Record ID] ) /3, 0 )
?
I think I got it, with what you sent me. Thank you!