3 Replies Latest reply on Mar 31, 2016 12:13 PM by Dhanashree Arole

    Calculated Field Format Issue

    Dhanashree Arole

      Hi Community,


      I have created ratio which is merely division of two measures. It works perfectly fine in one workbook



      The values in third column are computed as [Metric Canspam WDW] / [Metric Delivered] and displayed as Percentage with 3 float values.


      Now, I have another workbook that is identical, although deals with bigger numbers:



      As you can see, the Canspam Ratio WDW is totally incorrect!? Why?

      Is this related to data type of measures involved? Can that be adjusted somewhere in settings etc?


      What I expect to see is for code 9759, canspam ratio WDW should equal to 0.011599%

      What am I missing?


      Thanks for your feedback!