Activity Forums Salesforce® Discussions Non-deterministic Force.com formula fields in Salesforce?

  • Radhakrishna

    Member
    April 21, 2017 at 9:54 am

    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

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos