Jump to content

zero when if there is no data to display in a report


This topic is 2581 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi

 

I am trying to work out how to get my report to display a zero in the totals at the bottom of the full breakdown report if I don't have any data for that. Say for example I have no chaperones in for that day and unit, it will just leave it blank, but what I would love is a 0 to display at the totals at the end. Does this make sense?

 

I have attached the file.

 

thanks

 

Sarah

 

Crowd (9th edit) 10 backup copy.fmp12.zip

Link to comment
Share on other sites

Hi

 

I worked out how to get it to display a 0. Although for some reason it will not show up with the adult column. When you click on unit day report in scene details layout, the report shows a zero for the kids, stand ins and doubles, but not the adults, even though the formal looks the same. I also cannot get it to show zero for the chaperones. 

 

I have reuploaded it so you can see what i did. I put 0 + then the calculation.

 

Any help is much appreciated..

thanks sarah


file 

Crowd (9th edit) 10 backup copy 2.fmp12.zip

Crowd (9th edit) 10 backup copy 2.fmp12.zip

Link to comment
Share on other sites

I put 0 + then the calculation.

 

Clever, Sarah!  Not everyone picks up on that trick, even with many years of experience under their belts.   :thumbsup:

Link to comment
Share on other sites

This topic is 2581 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.