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

    Measure calculation ignore null or N/A field

    ahmad albab

      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

       

      ss.PNG