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!

       

      Dhanashree