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
Learn how to build the business apps that you need.