Hi WF Community,
Is there a way, on a report, to convert a calculated text field (Deployment Charges) to a currency (or number) field so that I can roll it up and sum it at a grouping level?
For example:
I'm aware of calculated data expressions, but not sure how to build this out in my report, based on my above request. Can anyone assist?
Thanks.
Nick
Topics help categorize Community content and increase your ability to discover relevant content.
Nick,
The ability to sum the data in a custom field is determined by the format of the custom form field. The Formats of Currency and Number will allow you to sum the column into the grouping. Unfortunately there is not a way to edit the format of an existing field so a new field would need to be created with one of the above formats to be able to sum this data in the report.
In this case you would open the existing custom form were the 'Deployment Charges' field exists and add a new field with the correct format selected. This article can walk you through adding a custom field to the form.
Hope this helps,
Views
Replies
Total Likes