Skip to Content
0
Former Member
Jun 04, 2008 at 03:55 AM

Formatting a running total

211 Views

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.