5 Replies Latest reply on Nov 6, 2018 8:07 AM by Deepak Rai

    Urgent :: Showing zeros when created a measure calculated field.

    siva Nageswara Rao

      Hey,

      I have created a calculated filed as follows.

      SUM(IF UPPER([Used IQ vs Act])='YES' THEN [Est vs Act] END)/SUM(IF UPPER([Used IQ vs Act])='YES' THEN [Job Cost] END)

       

      When I drag this measure on to the rows shelf it's showing zero values and when convert this in to Dimension then it's working as expected.

       

      Can you please explain the reason?

       

      Thanks