Have a Question?

<全てのトピック

吹き出しに表示させる金額にカンマをつけたい

金額を文字にするとカンマがなくなります。
マイナスと 18桁まで対応。小数点は未対応

if(isnull(Suryo__c),” “,if(Suryo__c<0,”-“,””)
&if(floor(abs(Suryo__c)/1000000000000000)=0,””,right(text(floor(abs(Suryo__c)/1000000000000000)),3)&”,”)
&if(floor(abs(Suryo__c)/1000000000000)=0,””,right(text(floor(abs(Suryo__c)/1000000000000)),3)&”,”)
&if(floor(abs(Suryo__c)/1000000000)=0,””,right(text(floor(abs(Suryo__c)/1000000000)),3)&”,”)
&if(floor(abs(Suryo__c)/1000000)=0,””,right(text(floor(abs(Suryo__c)/1000000)),3)&”,”)
&if(floor(abs(Suryo__c)/1000)=0,””,right(text(floor(abs(Suryo__c)/1000)),3)&”,”)
&if(floor(abs(Suryo__c)/1)=0,”0″,right(text(floor(abs(Suryo__c)/1)),3)))

数字は0表示する場合

f(AuctionRenban__c>=10000000,text(AuctionRenban__c),”0″&
if(AuctionRenban__c>=1000000,text(AuctionRenban__c),”0″&
if(AuctionRenban__c>=100000,text(AuctionRenban__c),”0″&
if(AuctionRenban__c>=10000,text(AuctionRenban__c),”0″&
if(AuctionRenban__c>=1000,text(AuctionRenban__c),”0″&
if(AuctionRenban__c>=100,text(AuctionRenban__c),”0″&
if(AuctionRenban__c>=10,text(AuctionRenban__c),”0″&text(AuctionRenban__c))))))))

Table of Contents