Last Modified Date: 31 Mar 2017
ResolutionCreate a calculated field similar to the following:
IF SUM([Invoice]) >= 1000000 THEN "$" + STR(ROUND((SUM([Invoice])/1000000),1)) + "M"
ELSE "$" + STR(ROUND(SUM([Invoice]),0))
Additional InformationThis calculated field returns a string, meaning it will work for labels but cannot be used in any numerical calculations or for totals.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials