4 Replies Latest reply: May 21, 2018 7:20 AM by Sunny Talwar 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