Forum Discussion
Quick_BaseJunki
6 years agoQrew Captain
I'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])))