Welcome to the community! Would it be possible to know a little more about your issue?
A screenshot of the error would help a lot!
A sample workbook (if available) would help even more, though!
Hey, Derrick. Thank you for the quick response!
I apologize if you have received other notifications for postings; I deleted them because I figured out how to create the calculation. I labeled the above calculation as "AB - Bed calculation..." and then created another calculation that looks like this: ZN(LOOKUP(SUM[AB - Bed Calculation...]),0). The image below shows it at work.
I do have a follow-up question, however.
The reason I created this calculation is because all these entries are going to be filtered by parameters. I needed the blank entries to have a zero so that the parameters would not intentionally exclude them.
The image below shows me trying to create a condition for the filter, but I keep on getting these errors: