I am using the following formula in combination with a parameter to allow the user to choose to display a running total.
If {?IncludeTotalObjects}='Y'
Then ToText({#TotalObjectCount})
Else ''
The issue that I'm having is that the total shows up in the format ###.## with a decimal point. I want to remove the decimal point and just display the ### to the left of the decimal point. How do I do that?
When I try to Format Field it does not give any numerical formatting options. I think that it is because I am using the ToText function to format the string. Is there another function that I need to use to strip the decimal point? Thanks in advance for any advice.