You need to sign in to do that
Don't have an account?
Formula results different on page layout vs report
I'm totally stumped and I'm hoping someone can shed some light here. I created a cross-object formula field on a custom object (I successfully compiled and saved the formula). I added the field to my page layout and, as expected, can view a record and see a value displayed for my formula field.
What is not expected, however, is that the formula field for the SAME record as above now shows #Error! when I run a report or create a list view and include this field. In fact, all my custom object records show #Error! for this field when running a report or while in a list view.
Can anyone explain why the report doesn't return the same value as when looking at an individual custom object record?
Kristin