2 Replies Latest reply on Aug 23, 2016 7:44 AM by Akhilesh Singh

    % Calculating Wrong

    Akhilesh Singh

      Hi All,

       

      I have Three measures. First () sum is 1,442,640, Second Sum is 117,044,001 last one is for Percentage calculation First/Second. It should be 81.87%. But it is giving me 76%.

       

      Below are the calculation for Percentage

       

      IIF([Second]=100,0,

      (ZN([Second]*[First],0))/[First])

       

      Please help me. How can i solve these type of issues.