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 ,
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand