Limit to two places after decimal in Amount Field
Raman Raghav Mar 8, 2018 4:18 PMHi 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.
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

Excel Capture.PNG 32.9 K