cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

remove dot from text at the end of characters

Hi Team, 

 

I have Overall Cost value like this : 

Concatenate("Overall Cost: ",Text(Sum(cOrderItems,TotalCost),"[$-en-US]$,###,##.##")

When there is no decimal values are there , still It is showing "." at the end (verall Cost: $197,160.) 

I would like to remove the dot at the end when there is no decimal points are there .Please help me on this 
 

Thanks in Advance , 

 

Mahesh

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,456)