ContributionsMost RecentMost LikesSolutionsHelp needed with complicated numeric formulaI inherited an application with a numerical formula that I cannot figure out. The formula is currently based on if "Year Flag" or "Prior Year Flag" field is checked. The problem is that when the Flag is unchecked for a particular year then it throws off the calculation. I need the calculation to not be dependent upon if it is checked as flagged or not and no matter how I try I can't get a formula that works. Here is the current formula: If( If([(Year) Can Have Actual Flag], If([(Prior Year Entry) Can Have Actual Flag], [(Calc) Actual Dollars Total Gross] - [(Prior Year Entry) Actual Cost Savings], [(Calc) Actual Dollars Total Gross]), If([(Prior Year Entry) Can Have Actual Flag], [(Calc) Budget Dollars Total Gross] - [(Prior Year Entry) Actual Cost Savings], If([(Prior Year Entry) Budgeted Cost Savings] > 0 or [(Prior Year Entry) Budgeted Cost Savings] < 0, [(Calc) Budget Dollars Total Gross]- [(Prior Year Entry) Budgeted Cost Savings], [(Calc) Budget Dollars Total Gross])) ) < 0 and [(Tactic/Initiative) Zero-out Negative Incremental], 0, If([(Year) Can Have Actual Flag], If([(Prior Year Entry) Can Have Actual Flag], [(Calc) Actual Dollars Total Gross] - [(Prior Year Entry) Actual Cost Savings], [(Calc) Actual Dollars Total Gross]), If([(Prior Year Entry) Can Have Actual Flag], [(Calc) Budget Dollars Total Gross] - [(Prior Year Entry) Actual Cost Savings], If([(Prior Year Entry) Budgeted Cost Savings] > 0 or [(Prior Year Entry) Budgeted Cost Savings] < 0, [(Calc) Budget Dollars Total Gross]- [(Prior Year Entry) Budgeted Cost Savings], [(Calc) Budget Dollars Total Gross])) ) ) I want to have the same calculations but remove[(Year) Can Have Actual Flag] and [(Prior Year Entry) Can Have Actual Flag]. Instead I want to use If(NotIsNull([(Calc) Actual Dollars Total Gross] for the Actual dollars andIf(NotIsNull([(Calc) Budget Dollars Total Gross] for the Budget dollar calculations. I just seem to be missing some logic or parenthesis no matter what I come up with. Any help appreciated.How can I remove the add new choice on a conditional drop-down?I have a conditional dropdown in my Projects Table called Related Tactic. The condition is set up to pull related tactics from a Related Initiative. I want to remove the Add new option from both of those fields as initiatives and tactics are not to be added from the Project Table. Is there a way to do this? I can't turn off "Add" permissions as they still need to be able to add new records - I just don't want them to add new initiatives or tactics from these two dropdowns.