Measure calculation ignore null or N/A field

[Anonymous]

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

[jonathandienst]

>> 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

[Anonymous]

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.

[sasiparupudi1 · Accepted solution]

use rangesum

Rangesum(Ascore,Bscore,Cscore)

[sunny_talwar]

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

The Crosstable Load

[Anonymous]

Thanks Sasidar.