Help needed with complicated numeric formula
I 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 ...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendI'm not familiar with a function called NotIsNull, but perhaps something like the following is what you're trying to achieve.
If([(Calc) Actual Dollars Total Gross]<>0, [(Calc) Actual Dollars Total Gross] - [(Prior Year Entry) Actual Cost Savings],
If([(Calc) Budget Dollars Total Gross]<>0, [(Calc) Budget Dollars Total Gross] -
If([(Prior Year Entry) Actual Cost Savings]<>0, [(Prior Year Entry) Actual Cost Savings], [(Prior Year Entry) Budgeted Cost Savings])))