• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1032
  • Last Modified:

How to show zero on null running total

I don't know much about CR and I'm trying to make a modifications to a report of outstanding balances for 30 days, 60 days, 90 days, etc. For each time period there is a running total but if there are no records for that total, it will display nothing. I would think there would be some simple option to have it show 0.00 instead of nothing but this seems to elude me.

How can I have the running total field display 0.00 if there are no records for that field? Keep in mind this is an old CR 8.5.
2 Solutions
Create a new formula in formula editor for this field.

eg. if YourRunningTotalField = 0 then "0.00" else YourRunningTotal

and insert this formula field on your report instead of the existing running total.
if nulls are the problem it would be
if isnull(YourRunningTotalField) then 0 else YourRunningTotal
Another idea would be to create a new formula field and total it

If IsNull({YourField}) then

pnicorpAuthor Commented:
Looks like I had the right idea, I was just trying to modify the running total field instead of creating a new field and referencing the running total. dhobale gave me the push in the right direction I needed but jgbreeden was also correct in that I needed to use IsNull. Here's an example of what I ended up using:

If IsNull({#30Days}) Then 0.00 Else {#30Days}

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now