Non-deterministic Force.com formula fields in Salesforce?

Hi Manpreet,

Here are examples of common non-deterministic formulas. Force.com cannot index fields that:

·         Reference other entities (i.e., fields accessible through lookup fields)

·         Include other formula fields that span over other entities

·         Use dynamic date and time functions (e.g., TODAY, NOW)

A formula is also considered non-deterministic when it includes:

·         Owner, autonumber, divisions, or audit fields (except for CreatedDate and CreatedByID fields)

·         References to fields that Force.com cannot index

o    Multi-select picklists

o    Currency fields in a multicurrency organization

o    Long text area fields

o    Binary fields (blob, file, or encrypted text)

·         Standard fields with special functionalities

o    Opportunity: Amount, TotalOpportunityQuantity, ExpectedRevenue, IsClosed, IsWon

o    Case: ClosedDate, IsClosed

o    Product: Product Family, IsActive, IsArchived

o    Solution: Status

o    Lead: Status

o    Activity: Subject, TaskStatus, TaskPriority