7 Replies Latest reply: Nov 2, 2012 7:54 AM by sivaraj seeman RSS

    Number format

    sriram s

      Hello

       

      My requirement is that I have certain fields as the range 0.00734836 , and 0.00865531.But I want that to convert to 734836 , 865531.

       

      Can anyone please suggest me how to resolve the above issue.

       

      Thanks

        • Re: Number format
          Michael Solomovich

          Can't you simply multiply it by 100,000,000?

            • Re: Number format
              sriram s
              Jul 2012Aug 2012Sep 2012Oct 2012Nov 2012Dec 2012Jan 2013Feb 2013Mar 2013
              1094968811250004089176366874423870218582110745132-132
              17568395917758022718750551810938704666853791833101132-132
              206106912212271175213210826177236626136155011803164812218367-132
              2996999992463579562333462072054819021923036591972061161271320271717628132
              5162987964592744003606372593849517072606704992563295582092451701078422591427046
              53377877348789289043477272035641905128754775527754678426552721619547741329323847
              56957605847020837847112202839839320030344363728979944027943283424117840154798763
              55265698656836001644575091442851535438334325238444043837524047528809488568660947
              1.698E+096901696536866613236857330124183949581.868E+0929972695727397718182455852
              3958287201.588E+095308941044958391594628593171.92E+09361807638295905731110429205
              109171251787281251.747E+09720960262551374428545209672550860917443774464259298231
              ----0.00364210.00339590.00399480.00412940.0025708
              ----0.00734860.00865530.00531920.0044680.0020597

               

              I am using the expression

               

              (Sum(distinct([Supply Plan])))

              & num(if(Plan_For_Month >=monthstart(today()),Sum(distinct([Supply Plan 1]))))

               

              and dimension is two month field.

               

              The highlighted dark numbers needs to be changed from 0.0073486 to 73486.

               

              But if I multiply it to 100,000,000  then all the values gets changes .But that should not happen

               

              Please advise some solution to the above problem