I have a report I created that captures Budget, Actual and Actual vs Budget Variance (Budget - Actual). I am in the process of updating the financials for some of my projects. So there are instances where some projects do not have any budget or expenses set. However when I run my report I get $(9,999,999,000) for actuals. I tried to format the list but that did not work I also tried Coalesce([Actual Expense],0) but this did not work eiter.. Does anyone else have a suggestion. Thanks!
Hadji M. Godih | Market Intelligence and Product Development Manager
Nippon Life Insurance Company of America
521 5th Avenue, 5th Floor | New York, N.Y. 10175
Office: (212) 909.0758 | Fax: (212) 681.3547
www.nlia.com | h-godih@nlia.com