Hi

 

I have a 0+ sum calculation in six of my fields. I have used this script on another database with exactly the same formula and the database is pretty much the same, but for some reason the script is not working and not showing zero when it is blank. 

 

I cannot see why it is not working, I have even rewritten the calculation from scratch to make sure.

 

Any help welcomed.

 

Thanks

 

Sarah

 

 

I forgot to say it is when you click the Unit Day report button in Scene Details layout.....

Crowd Breakdown step 2 adding in zeros.fmp12.zip

Try unchecking the “Do not evaluate if all referenced fields are empty” checkbox.

Oliver you genius, thank you for the fresh eyes. I was starring back and forth between the two databases for ages and my eyes just were not seeing that part was different. many many many thanks.. you stopped me going mad looking at it...