5 Replies Latest reply: Jun 26, 2018 11:52 PM by ahmad albab

# Measure calculation ignore null or N/A field

Dear Team,

Please confirm how can i create my measure.for total column. i want to ignore null & N/A.

For example No 2,

8+2=10

Available score=2

10/2=5

Divide by 2 to reduce range (1-5) because initial score is (1-10)

5/2=2.5

• ###### Re: Measure calculation ignore null or N/A field

>> how can i create my measure

Except you have given no information about fields or tables, and ...

>>Available score=2

>>Divide by 2 to reduce range (1-5) because initial score is (1-10)

No idea what you mean by these statements

• ###### Re: Measure calculation ignore null or N/A field

Dear Jonathan,

Period,No, Ascore,Bscore,CScore is my field.

Total is the measure i want to get.

Available score means it is not null or N/A. For row no 2, only Bscore not available. So, available score is 2 which is Ascore & Cscore.

i just divide by 2 because i want the range of total score to be from 1-5. initial score for Ascore,Bscore,Cscore is from 1-10.

• ###### Re: Measure calculation ignore null or N/A field

use rangesum

Rangesum(Ascore,Bscore,Cscore)

• ###### Re: Measure calculation ignore null or N/A field

Thanks Sasidar.

• ###### Re: Measure calculation ignore null or N/A field

Why don't you transform your score data so that the calculation can be made easier