8 Replies Latest reply: Mar 9, 2018 2:56 PM by Rob Wunderlich RSS

    Limit to two places after decimal in Amount Field

    Raman Raghav

      Hi All,

      When I export the Amount  from the report to excel sheet its showing more than two places after the decimal which doesn't make sense .I checked the data in database there its only two places after the decimal. Can anyone please suggest me .Please find the attachments for better understanding.

       

      Report capture.PNG

      Measure I used :

      Money( 

                     

                  if(WildMatch([Paid Range New],'>$500M'),

                     sum({<[Supplier]={"=Sum(amount)>=500000000"}>}$(vAmount)),         

                       if(WildMatch([Paid Range New],'$500M - $100M'),

                        sum({<[Supplier]={"=500000000>sum(amount) and 100000000<sum(amount)"}>}$(vAmount)),         

                         if(WildMatch([Paid Range New],'$100M - $50M'),

                        sum({<[Supplier]={"=100000000>=sum(amount) and 50000000<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$50M - $10M'),

                        sum({<[Supplier]={"=50000000>=sum(amount) and 10000000<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$10M - $1M'),

                        sum({<[Supplier]={"=10000000>=sum(amount) and 1000000<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$1M - $500K'),

                        sum({<[Supplier]={"=1000000>=sum(amount) and 500000<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$500K - $400K'),

                        sum({<[Supplier]={"=500000>=sum(amount) and 400000<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$400K - 100K'),

                       sum({<[Supplier]={"=400000>=sum(amount) and 100000<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$100K - $25K'),

                       sum({<[Supplier]={"=100000>=sum(amount) and 25000<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$25K - $2500'),

                       sum({<[Supplier]={"=25000>=sum(amount) and 2500<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$2500 - $100'),

                        sum({<[Supplier]={"=2500>=sum(amount) and 100<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'$100 - $0'),

                        sum({<[Supplier]={"=100>=sum(amount) and 0<sum(amount)"}>}$(vAmount)),

      if(WildMatch([Paid Range New],'<$0'),

                        sum({<[Supplier]={"=0>=sum(amount)"}>}$(vAmount))     

       

       

      )))))))))))))       

           

               /$(vAmountDivisor),$(vFormat))

       

      TIA