ContributionsMost RecentMost LikesSolutionsRe: IF Statement in a Calculated Column in a Summary ReportThis is my problem- I don't have the data separated into a parent/child relationship. I have everything rolling up to one table. It looks like I'll need to separate it into two tables to do what I need. Thank you Michael!Re: IF Statement in a Calculated Column in a Summary ReportI was hoping that wasn't the answer. That's exactly what I was trying to do. Looks like I'll need to separate the budget and validations into two separate tables and use summary fields instead. Thank you!Re: IF Statement in a Calculated Column in a Summary ReportI checked my fields and they were both selected to "Treat blank values as "0" in calculations". I've tried different formulas and it seems like only straight calculations work, addition/subtraction/etc.IF Statement in a Calculated Column in a Summary ReportI have a table named "Validations". Within that table, I have two record types, "Budget" and "Validated". My form has a "Budget Units" field and a "Validated Units" field. I am trying to create a Summary report that roles up the Budgeted Units and Validated Units for one project on one row. Then, I am trying to use the formulaIf([Validated]>[Budget],[Budget],[Validated]) but I'm not getting any results. Any pointers on where I'm going wrong? Re: Multiple Children with Multiple Parentsawesome, thank you for confirming!Re: Multiple Children with Multiple ParentsI populated data in it. I have a Maximum Summary Date if the field is not blank but it's still populating a Maximum Date. I found a work around, it's not the cleanest but it does the job. I have a count of all the blank date fields and a formula field that will only use the maximum date if the blank date count is 0. Not sure if this is the best way.Re: Multiple Children with Multiple ParentsI'm finally working with real data in the new table- "Dependencies". I'm having trouble with the maximum summary dates not working now. What I have is a lookup from the original Permit table to the Dependency table, then a summary to the Construction Project table. It used to work when I didn't have the middle table. I'm not sure what I'm doing wrong now. Thank you!Re: Multiple Children with Multiple ParentsThank you so much for the detailed steps, you don't know how helpful you've been in making this huge transition for our company's app. Thank you again!Re: Multiple Children with Multiple ParentsYou're devoted, I like it! All of the permits are for underground work. The only thing that differentiates the permits are the permit numbers. I have another table setup for aerial permits. So whatever I end up doing to the permit table, I'm going to replicate on the aerial permit table. Hope this all makes sense.Re: Multiple Children with Multiple ParentsI feel honored that you returned on my behalf :) That definitely helped me with #2 on my list! Thank you so much! I would still like to figure out how to pull the permit statuses onto the construction record.